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

How do I turn a list into a table?

1011

How to use transactions efficiently : transact sql

1116

What is an implicit commit?

1103

How many primary keys can a table have?

1058

Can we rename a column in the output of sql query?

1042

Is not null in sql?

1045

What is consistency?

1187

What are all different types of collation sensitivity?

1075

Describe types of sql statements?

1105

What is query optimization in sql?

1043

how to use in conditions? : Sql dba

1062

What is the difference between sql, mysql and sql server?

1176

what is the difference between myisam static and myisam dynamic? : Sql dba

1114

what are enums used for in mysql? : Sql dba

1229

what's the difference between a primary key and a unique key? : Sql dba

1111