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 find duplicate records in a table?

514


Does sql support programming?

557


What are expressions?

563


How to write html code in pl sql?

580


What is bitemporal narrowing?

737






What is varchar sql?

620


What is sql clause?

543


What is pl sql code?

591


Is id a reserved word in sql?

663


What is sql injection vulnerability?

494


How to prepare for oracle pl sql certification?

569


how to shut down the server with 'mysqladmin'? : Sql dba

549


What is sql rowcount?

559


What sql does db2 use?

544


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

508