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

Answer Posted / unknown

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

Is This Answer Correct ?    1 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how can we destroy the session, how can we unset the variable of a session? : Sql dba

543


How to fix oracle error ora-00942: table or view does not exist

567


Can you sum a count in sql?

559


Does sql between include endpoints?

552


What is dynamic query?

539






What is the use of procedures?

539


How do I create an index in word?

540


how to get @@error and @@rowcount at the same time? : Sql dba

525


Write a sql query to find the names of employees that begin with ‘a’?

576


how to fetch common records from two tables? : Sql dba

625


How do I find sql profiler?

514


What is sqlcontext?

549


What is difference between sql and mysql?

529


What port does sql server use?

504


What is the purpose of cursors in pl/sql?

631