how to find the second highest salary from emp table?
- 211 Answers
- 322096 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 / mohamed hussain
select salary from
(select salary,Dense_RANK() over (Order by salary desc) as
Level from salary) TMP
where Level=@Level
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the two types of exceptions.
What are sql commands?
What if we write return in procedure?
What is out parameter used for eventhough return statement can also be used in pl/sql?
Write a query to display the current date in sql?
what are the 'mysql' command line arguments? : Sql dba
What is the usage of nvl function?
What is interval partition?
Does execute immediate commit?
Explain autonomous transaction.
Which is better join or inner query?
What is execute immediate?
How does join work in sql?
what are the type of locks ? : Sql dba
What is the left table in sql?
