how to find the second highest salary from emp table?
- 211 Answers
- 322606 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 / ravi
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC) a
ORDER BY salary
where n is the nth highest salary
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Is left join inner or outer?
Where do we use pl sql?
How much ram can sql express use?
What is composite primary key in sql?
give the syntax of grant and revoke commands? : Sql dba
Can we use insert statement in function?
i have some prob lem to tell me about my self in interview first round ...
What does select * from mean in sql?
What is the file extension for sql database?
What is a schema sql?
What is the full form of sql?
What is the use of non clustered index?
how many sql ddl commands are supported by 'mysql'? : Sql dba
How to rename a column in the output of sql query?
What is the benefit of foreign key?
