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

Is sql open source?

970

What is nosql vs sql?

1174

What is procedure explain with example?

956

State some properties of relational databases?

1056

what are the t string functions available in tsql? : Transact sql

1003

How do I edit a stored procedure?

989

What is execution plan in sql?

1041

What is the use of index in sql?

1015

Is primary key is clustered index?

999

Can we edit a view in sql?

983

What is a record in pl/sql?

1141

What is $$ in sql?

988

what are the advantages of using stored procedures? : Sql dba

1104

explain mysql aggregate functions. : Sql dba

984

Why does sql need a server?

1034