Interested to Buy Any Domain ? << Click Here >> for more details...
how to find the second highest salary from emp table?
- 211 Answers
- 373256 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 / rahul thakur
select top 1 salary from emp where id not in (select top1 id from emp order by salary desc)order by salary desc.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What are all the different types of indexes?
what are the different functions in sorting an array? : Sql dba
Are sql database names case sensitive?
How do you optimize a stored procedure in sql?
What does select * from mean in sql?
Does sql use python?
How many clustered indexes can you have?
How do you declare a variable in pl sql?
what is auto increment? : Sql dba
Why functions are used in sql?
What is an implicit commit?
What is cte?
Describe sql comments?
State some properties of relational databases?
Can you skip header records while loading? : aql loader
