Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 368179 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 / amy
select TOP salary from employee where salary in( select TOP 2 salary from employee order by salary desc) order by salary asc
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Differentiate pl/sql and sql?
What is coalesce in sql?
How do I run a program in pl sql?
How would you pass hints to the sql processor?
What is pl sql and why it is used for?
Can we commit inside a trigger?
Why do we use procedures in pl sql?
what is a constraint? Tell me about its various levels. : Sql dba
When you have to use a default "rollback to" savepoint of plvlog?
Whis is not false in primary key?
what is offset-fetch filter in tsql? : Transact sql
What is inner join in sql?
How delete all data from all tables in sql?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
What is sql used for?
