select min(sal) from EMP where sal in(select top n sal from EMP order b

How to select nth record from a table?

Question Posted / veeresh kethari

Answer Posted / veeresh kethari

select min(sal) from EMP where sal in(select top n sal from
EMP
order by SAL desc)

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain how dts is used to extract, transform and consolidate data?

1007

Explain for xml explicit mode?

983

How to convert numeric expression data types by assignment operations?

1097

What is a covered index?

949

Can we update data in a view?

1040

What is sql injection? How to protect against sql injection attack?

1006

How do you test your database? : sql server database administration

1028

What is the data tier application?

169

What is attribute hierarchy? : sql server analysis services, ssas

1031

How to access the deleted record of an event?

1042

What are key, name and value columns of an attribute? : sql server analysis services, ssas

1025

What is the difference between rank and dense_rank?

1104

Explain how you can deploy an SSRS report?

154

what is a sub-report?

142

What are the steps you will take to improve the performance of a poor performing query?

985