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

Why is sql server log file full?

979

What does the on delete cascade option do?

966

How do I edit a stored procedure in sql server?

883

What is trigger explain with program?

934

In which tcp/ip port does sql server run? Can it be changed?

948

How to insert new line characters into strings?

937

Differentiate between SQL and ORACLE joins and write their syntax.

981

What is candidate key with example?

925

System variable and temporary variables

2185

How the authentication mode can be changed?

1078

What is difference between materialized view and view?

879

What is the difference between Normalization and De-normalization?

1031

What is not null constraint?

1055

Is it possible to replicate data from sql server to oracle? : sql server replication

1036

What is the optimization being performed in oracle and SQL Server?

999