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

Is it possible to pass parameters to triggers?

575


What is multiple columns?

574


How to process query result in pl/sql?

564


What are hotfixes and patches?

529


Explain the uses of a database trigger?

571






Can we insert data into view?

527


Are stored procedures compiled?

525


Explian rowid, rownum? What are the psoducolumns we have?

574


What is the most important ddl statements in sql are?

523


how to start mysql server? : Sql dba

613


What are character functions?

630


What does := mean in pl sql?

555


What do you understand by pl/sql records?

535


List different type of expressions with the example.

551


What is sql catalog?

568