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 tune a sql query?

725

What is the importance of sqlcode and sqlerrm?

1055

what are the authentication modes in sql server? : Sql dba

734

What is a unique key and primary key and foreign key?

742

What are different joins used in sql?

731

What are analytic functions in sql?

743

What are inner and outer joins examples of both?

691

What are the different types of database management systems?

723

Which column of the user triggers data dictionary view displays the database event that will fire the trigger?

777

Is sql easier than java?

734

what are the different functions in sorting an array? : Sql dba

766

how many columns can be used for creating index? : Sql dba

675

how are mysql timestamps seen to a user? : Sql dba

773

How to handle bulk data?

1051

Can we insert data into materialized view?

710