find the 3rd max salary

Answer Posted / vasanth

SELECT min(Salary)
FROM (SELECT TOP 3 Salary FROM dbo.tblPopulation
GROUP BY [Population (in Millions)]
ORDER BY [Population (in Millions)] DESC ) TEMP

Is This Answer Correct ?    0 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How you can minimize the deadlock situation?

557


Do you know what is a trace frag? Where do we use it?

560


Explain the difference between HTTP and HTTPS in database?

564


What are the operating modes in which database mirroring runs?

612


Why should one not prefix user stored procedures with ‘sp_’?

599






what are the new features introduced in sql server 2000? : Sql server database administration

552


Why the trigger fires multiple times in single login?

732


What is the process of normalization?

562


What is blocking and how would you troubleshoot it? : sql server database administration

598


What is the report model project?

103


What are the built in functions in sql server?

493


What is dynamic cursor in SQL SERVER?

567


What is difference between group by and having?

566


How many null values we can have in a unique key field in sql server?

560


What is sleeping status in sql server?

526