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

How to find the source of a table in sql server?

993

What is named query? : sql server analysis services, ssas

958

What are the different index configurations a table can have?

955

What is the purpose of linked server configuration in sql server?

1042

How to use copy and concatenate commands in SQL?

1139

What are data files?

1034

Why truncate is ddl command?

1058

What is abstracting periodical?

939

Why should you use or avoid select * statements?

1020

Are connections to sql server encrypted?

996

What is indexing explain it with an example?

1005

Explain ms sql server reporting services vs crystal reports?

910

What is a linked server in sql server?

1073

What are the requirements on sql server network connections?

973

How to list all columns in a table using odbc_columns()?

972