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 many clustered indexes there can be on table ?

1072

What are actions, how many types of actions are there, explain with example? : sql server analysis services, ssas

1070

What is bcp? When does it used?

1044

How to recompile stored procedure at run time?

1118

What is 2nf normalization form?

1203

What do you understand by a stored procedure?

1153

How do I view a stored procedure in sql server query?

981

Sql studio em braces a variety of capabilities, but will I need them all? Is there a simpler product ? : sql server management studio

953

Is a primary key unique?

1036

Explain candidate key, alternate key, and composite key?

1058

What is clustered index

1060

How is sql server used?

1015

Is null in sql server?

1043

do you know how to configure db2 side of the application? : Sql server database administration

1100

What are the disadvantages of merge replication?

1512