a query to select maxmun 3 salaries of employee table

Answer Posted / elumalai.k

select top 3 salary from employee order by salary desc

Is This Answer Correct ?    5 Yes 7 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How would you go about verifying the network name that the local_listener is currently using?

1598


What are the various types of snapshots ?

551


How to write numeric literals in oracle?

598


Select all the employees who were hired in last 2 years and who works in dept where max managers are working.

2438


Difference between hot backup vs. Cold backup?

600






Is postgres faster than oracle?

552


What is the order of defining local variables and sub procedures/functions?

589


What is the difference between translate and replace in oracle?

636


What are named parameters?

602


What is oracle sid?

498


How to store only time; not date and time?

546


How to assign a table row to a record variable?

569


Query to retrieve record for a many to many relationship ?

2071


What is Reduced List of Values?

1693


How do I use os authentication with weblogic jdriver for oracle and connection pools?

562