How to find the second largest salary in the emp database and
also How to find 3rd,4th and so on ........ in the emp database
plz mail the answer @ mak2786@gmail.com
Answer Posted / neon
select salary from emp
where salary = (select max(salary) from emp
where salary <>(select max(salary) from emp)
| Is This Answer Correct ? | 8 Yes | 3 No |
Post New Answer View All Answers
Explain few of the new features of sql server 2008 management studio
How to create stored procedures with parameters in ms sql server?
How to test values returned by a subquery with the in operator?
What is the correct order of the logical query processing phases?
Define tempdb database?
How do I make a resultset scrollable?
how you can deploy an ssrs report?
What is built-in/administrator?
What is the use of toad or sqldbx.?
What is sub-query in sql server?
What is the difference between a local and a global temporary table?
What happens when converting big values to integers?
Explain Geography datatype in SQL Server
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to create new tables with "create table" statements in ms sql server?