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
query optmization techniques and quwry analyser+projects+ppts
What is max rowid in oracle?
How to pass a parameter to a cursor in oracle?
What are the system predefined user roles?
How to select an oracle system id (sid)?
What are a query and state the different types of queries and their uses?
What are the limitations oracle database 10g xe?
What is a cursor and what are the steps need to be taken?
Hi Can any one tell me what are the API's used in requisition import.
How index is implemented in oracle database?
What is literal?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
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.
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What is the oracle implicit cursor?