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 / ranjith
Select Max(Salary) from emp_database where Salary < (Select
Max(Salary) from emp_database)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Is port 1433 secure?
Explain what is raid and what are different types of raid levels?
What is SQL Server?
What are the different Authentication modes in SQL Server and how can you change authentication mode?
Difference between report and query parameter. Why do we need different type of parameter?
What type of Index will get created after executing the above statement?
What is the command dbcc checkdb used for?
can an automatic recovery be initiated by a user? : Sql server administration
What are the tool windows in sql server management studio? : sql server management studio
What is stored in the mssqlsystemresource database? : sql server database administration
How to create a user to access a database in ms sql server using "create user" statements?
What is executereader?
Can we check locks in database? If so, how can we do this lock check?
How many types of relations are there between dimension and measure group? : sql server analysis services, ssas
What is cdc in sql server?