select * from emp e where 2=(select count(*) from emp where sal>=e.sal)

how to retrive only second row from table?

Question Posted / naresh

Answer Posted / naresh

select * from emp e where 2=(select count(*) from emp where
sal>=e.sal);

Is This Answer Correct ?

0 Yes

3 No

Please Help Members By Posting Answers For Below Questions

what is the difference between union and union all? : Sql dba

976

what are the different index configurations a table can have? : Sql dba

939

Can a primary key be a foreign key?

970

Write a query to find the names of users that begin with "um" in sql?

926

explain the advantages and disadvantages of stored procedure? : Sql dba

957

What are the types of records?

953

What is secondary key?

882

What is structural independence and why is it important?

979

What are the uses of merge?

1120

define sql update statement ? : Sql dba

1051

Which command is used to delete a trigger?

1262

What do you mean by table in sql?

940

What are sql functions? Describe the different types of sql functions?

1059

What is the use of & in pl sql?

988

Why do we need pl sql?

937