select distinct(salary) from table t1 where 4=(select count(distinct(salar

how to find nth highest salary

Question Posted / kiran k s

Answer Posted / kiran k s

select distinct(salary) from table t1
where 4=(select count(distinct(salary))from table t2
where t2.salary >= t1.salary);

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can a table have 2 foreign keys?

959

What is the bookmark lookup and rid lookup?

1035

How retrieve field names from the table in SQL through JAVA code?

1959

What is the default fill factor value?

1131

Why do we backup Active Directory ?

1100

Can we linked SharePoint to a SQL database?

1078

When I delete any data from a table, does the sql server reduce the size of that table?

1064

How to generate create procedure script on an existing stored procedure?

1069

How do I start sql server 2017?

987

Why Master database is required?

1189

What is plan freezing?

1016

can a table be moved to different filegroup? : Sql server administration

1021

What are pessimistic lock and optimistic lock?

1142

What is trigger and different types of Triggers?

1201

What action plan is preferred if sql server is not responding?

1159