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

Is it possible to pass parameters to triggers?

777


Is sql a backend language?

844


What is where clause in sql?

734


What is a natural join sql?

706


what are the different index configurations a table can have? : Sql dba

750






What is a schema? How is it useful in sql servers?

792


what is the different between now() and current_date()? : Sql dba

703


What is a design view?

700


Is it mandatory for the primary key to be given a value when a new record is inserted?

931


What are stored procedures used for?

729


What is sql catalog?

765


What is difference between stored procedure and trigger?

744


what are the advantages and disadvantages of views in a database? : Sql dba

764


What plvcmt and plvrb does in pl/sql?

1063


Is microsoft sql free?

778