how to retrieve the top 3 salaries of the table using rownum

Answer Posted / sumalatha

select top 3 esal from employee order by esal desc

Is This Answer Correct ?    4 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the difference in execution of triggers and stored procedures?

573


What are local and global Indexes and where they are useful.

932


how to select first 5 records from a table? : Sql dba

509


What is percent sign in sql?

723


What is dense_rank in sql?

544






what is the difference between cluster and non cluster index? : Sql dba

559


How do I create a sql script?

542


What is sql injection vulnerability?

498


What is difference between primary and secondary key?

519


What are the differences between implicit and explicit cursors?

523


What type of join is sql join?

533


What does dml mean?

548


What are the basic techniques of indexing?

577


What is pessimistic concurrency control? : Transact sql

590


What makes a good primary key?

527