Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 361467 Views
- CIS, Cognizant, Cosmosoft, DAS, EDS, GreenTech, HOV Services, IBM, Infosys, National Institute of Science and Technology, Patni, Persistent, Polaris, TCS, Wipro, Yardi, Zensar, I also Faced
- E-Mail Answers
Answer Posted / bharat g
select * from (select ename,sal,dense_rank() over (order by sal desc) ranking from emp) where ranking=2;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
The select into statement is most often used to create backup copies of tables or for archiving records?
how to get a list of columns in an existing table? : Sql dba
How do you define a foreign key?
Can I join the same table twice?
What is orm in sql?
How to find 3rd highest salary of an employee from the employee table in sql?
how many tables will create when we create table, what are they? : Sql dba
What is pl sql collection?
How do you delete a table?
What is localdb mssqllocaldb?
How do you update a value in sql?
Why cross join is used?
What is the difference between alter trigger and drop trigger statements?
What are different types of triggers?
Hi am new to PLSQL & facing problems in writing code like in SP, Functions, so any one having some SP coding with in depth explanation please share with me my Email ID suvarnaatsuvarna@rediffmail.com Or taking tanning on this please do contact me
