find out the third highest salary?

Answer Posted / anish nama

select Max(salery) from salery where salery IN( select
top N salery from salery order by salery asc)

Is This Answer Correct ?    1 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?

1605


Explain the different normalization forms?

591


What is oracle database 10g express edition?

595


How do I spool to a csv formatted file using sqlplus?

548


What is oracle data type?

555






Differentiate between post-database commit and post-form commit?

543


Explain the use of rows option in imp command.

604


How to load data from external tables to regular tables?

539


What is a nvl function?

561


How to delete an existing row from a table in oracle?

641


How to use "in" parameter properly?

617


What is analyze command used for?

577


How to call a stored function in oracle?

573


What is the relationship among database, tablespace and data file?

542


Difference between cartesian join and cross join?

543