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 view explain with example?

919

Where do we use pl sql?

982

How delete all data from all tables in sql?

932

How do I run a sql query?

1001

Explian rowid, rownum?

996

Explain dml and ddl?

963

how to see the create table statement of an existing table? : Sql dba

987

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7272

What are stored procedures used for?

989

What is the difference between stored procedure and view?

1008

how many sql dml commands are supported by 'mysql'? : Sql dba

1098

What is union?

1137

Can we connect to postgresql using sql developer?

982

what is top in tsql? : Transact sql

1087

What is indexing in sql and its types?

1058