SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY IN (SELECT DIS

how to find nth highest salary

Question Posted / dilip

Answer Posted / dilip

SELECT MIN(SALARY) FROM tablealies.Table_Name WHERE SALARY
IN (SELECT DISTINCT TOP N MAX(SALARY) FROM
tablealies.Table_Name ORDER BY SALARY DESC)

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

You want to implement the one-to-one relationship while designing tables. How would you do it?

1017

Define outer join in sql server joins?

993

Is natural join and equi join same?

1032

What is local temp table?

1024

What is an etl file?

1009

What are cascading parameters in ssrs reports?

236

Explain transaction server implicit?

1028

How many columns can exist together per table?

1211

What information is maintained within the msdb database?

1023

How do you delete a data source?

1052

How do you delete duplicate records in sql server?

1127

What do you understand by a stored procedure?

1154

Do you know exporting and importing utility?

1108

What is use of @@ spid in sql server?

1275

What is a ddl statement?

962