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 / jey ganesh
select min(sal) from employee where sal in(
select top 3 sal from employee order by sal desc)
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What do you understand by coalesce in sql server?
How can we call UDF(User Define Function) using C# code in ASP.net ?
What is the process of indexing?
Where in ms sql server is ’100’ equal to ‘0’?
What is the query and subquery?
Explain transaction server consistency?
What is extended stored procedures?
What is microsoft sql server?
How can you start sql server in different modes?
What is identity?
Is it possible to call a stored procedure within a stored procedure?
What are the types of containers in ssis?
How do you create a data source?
What is row_number()?
What are the new features of sql server 2008 r2 reporting service?