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
Explain Capacity planning to create a database? and how to monitor it?
What are date and time data types in ms sql server?
How to use “drop” keyword in sql server and give an example?
Differentiate between mongodb vs. Sql server?
What are a database and a data warehouse?
What are sql server procedures?
Explain relational data?
What is a field in a table?
What are the differences between DDL, DML and DCL in SQL?
What is #table in sql server?
What are drillthrough reports?
Can we create clustered index on composite key?
How do I completely remove sql server instance?
How to Sync Two SQL Azure Databases?
What is sql collation?