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

Answer Posted / mamta

Select sal
from salary_tbl
where rownum <= 2
order by sal desc;

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do sql triggers work?

550


how to install mysql? : Sql dba

580


How do I find duplicates in the same column?

541


What is pl sql block in dbms?

524


Is there a way to automate sql execution from the command-line, batch job or shell script?

555






what is datawarehouse? : Sql dba

565


How do I copy a table in sql?

515


Explain the commit statement.

611


Can we insert data into materialized view?

503


What does bitemporal mean?

595


What are the operators in sql?

523


how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba

543


What is memory optimized table?

571


Can we insert delete data in view?

542


what are the 'mysql' command line options? : Sql dba

554