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 / prathapshankarshiva
select max(salary) from (select salary from table1 where
salary<(select max(salary) from table1))
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between stored procedure and the dynamic sql?
Why use view instead of a table?
What is application role in sql server database security? : sql server security
Can sub report data source be different from that of the parent report?
How many clustered indexes there can be on table ?
explain the difference between oracle- sql and sql server sql ? if both are same y we r using 2 sw.s?
What are the characteristics of modern DBMS?
How to list all dsn entries on your local machine using odbc_data_source()?
what is database replicaion? What are the different types of replication you can set up in sql server? : Sql server database administration
What are four major operators that can be used to combine conditions on a where clause?
Please illustrate physical database architecture? : SQL Server Architecture
What is advantage data architect?
What is view in sql?
how you can configure a running aggregate in SSRS?
Tell me what is the difference between locking and multi-versioning?