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
What is the use of custom fields in report?
What is PROJECTION Operation?
How many database files are there in sql server 2000?what are they?
What is the difference between inner join and equi join?
What do you mean by a dependent functionality in a build?
What does <> symbol mean?
How can you tell if a database object is invalid?
Explain some stored procedure creating best practices or guidelines?
What the different topologies in which replication can be configured?
What are the types of ssrs?
In what version of sql server were synonyms released?
How to modify an existing user defined function?
What is the function of sql server agent windows service?
code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that
what is normalization? Explain different levels of normalization? : Sql server database administration