Select salary from (select salary from employees) where rownum <=2;

how to retrieve the top 2 salaried persons from a database?

Question Posted / unknown

Answer Posted / unknown

Select salary from (select salary from employees) where
rownum <=2;

Is This Answer Correct ?

1 Yes

7 No

Please Help Members By Posting Answers For Below Questions

What does a pl/sql package consist of?

931

What is difference between ms sql and mysql?

914

What is sqlerrm?

883

how can we repair a mysql table? : Sql dba

916

how can we find the number of rows in a table using mysql? : Sql dba

1031

What are all the common sql functions?

971

How to execute a stored procedure?

1037

What is faster join or subquery?

962

Why we use joins in sql?

926

what does the t-sql command ident_incr does? : Transact sql

1012

What type of database is sql?

979

Can we use two order by clause in query?

919

Which type of cursor is used to execute the dml statement?

896

How you improve the performance of sql*loader? : aql loader

957

What is pl sql script?

979