select the 3rd maximum salary from sql server database if 4
(just an example In practically I may not know the exact
situation) of the highest salaries are equal.
Answer Posted / sunil nair
SELECT EmpID,Salary from tblSalary a where 3=(select count
(EmpID) from tblSalary b where b.empid=a.empid)
for any RDBMS
| Is This Answer Correct ? | 2 Yes | 13 No |
Post New Answer View All Answers
What is a raid and what are different types of raid configurations?
Are there any preferred steps that need to be taken care of before starting the installation of sql server 2000?
Disadvantages of the indexes?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
How to create and drop temp table in sql server?
What is deploy, process and build? : sql server analysis services, ssas
How to recompile stored procedure at run time?
What are relationships and mention different types of relationships in the dbms
What is Federation Root Database?
Distinguish between nested subquery and correlated subquery?
How many ways to create table-valued functions?
What is inner join in sql server joins?
What is the maximum size of sql server database?
How to grant a permission in ms sql server using "grant execute" statements?
What structure can you implement for the database to speed up table reads?