select min(sal) from employee where sal in( select top 3 sal from employee

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.

Question Posted / jey ganesh

8 Answers
12528 Views
TCS, I also Faced
E-Mail Answers

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

Please Help Members By Posting Answers For Below Questions

What do you understand by coalesce in sql server?

1043

How can we call UDF(User Define Function) using C# code in ASP.net ?

6862

What is the process of indexing?

986

Where in ms sql server is ’100’ equal to ‘0’?

1065

What is the query and subquery?

1060

Explain transaction server consistency?

949

What is extended stored procedures?

944

What is microsoft sql server?

956

How can you start sql server in different modes?

953

What is identity?

1002

Is it possible to call a stored procedure within a stored procedure?

950

What are the types of containers in ssis?

1148

How do you create a data source?

889

What is row_number()?

970

What are the new features of sql server 2008 r2 reporting service?

206