find out the third highest salary?

Answer Posted / sabapathi

select sal from employee
where sal=(select min(sal) from employee
where sal>(select min(sal) from employee
where sal>(select min(sal) from employee)))

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

query optmization techniques and quwry analyser+projects+ppts

1929


What is max rowid in oracle?

551


How to pass a parameter to a cursor in oracle?

593


What are the system predefined user roles?

585


How to select an oracle system id (sid)?

585






What are a query and state the different types of queries and their uses?

510


What are the limitations oracle database 10g xe?

570


What is a cursor and what are the steps need to be taken?

599


Hi Can any one tell me what are the API's used in requisition import.

1485


How index is implemented in oracle database?

594


What is literal?

589


What will be the syntax to find current date and time in format "yyyy-mm-dd"?

567


when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.

1469


In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col

3700


What is the oracle implicit cursor?

596