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

What is ceil and floor in oracle?

579


How to create a stored function in oracle?

590


What are the types of trigger in oracle?

576


what is reindexing?

1179


How can we delete duplicate rows in a table?

567






Can we create trigger on materialized view in oracle?

565


Can you drop an index associated with a unique or primary key constraint?

587


What is the difference between a hot backup and a cold backup in oracle?

576


Explain the use of record option in exp command.

537


Explain the use of consistent option in exp command.

552


how can db_files > maxdatafiles since db_files is for instance and the later is for database

2175


definition of cluster and non-clustered index?

2479


How can we find out the current date and time in oracle?

641


What is a directory object?

591


How to shutdown your 10g xe server from command line?

556