find out the third highest salary?
Answer Posted / sudesh indore
select ( salary) as sal from employee ORDER by
salary DESC limit 2,1
------------
i hope that will help u thanx
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
How translate command is different from replace?
How to concatenate two text values in oracle?
What is private procedure oracle?
What is Segment Advisor in Oracle?
Why does Oracle not permit the use of PCTUSED with indexes?
In SAP ECC 6.0 , under DB02 tcode , Tablespace name to be explain stepy step all the col
What are the extensions used by oracle reports?
What spfile/init.ora file parameter exists to force the CBO to make the execution path of a given statement use an index, even if the index scan may appear to be calculated as more costly?
How is it different from a normal table?
How to create a table index in oracle?
Why does oracle 9i treat an empty string as null?
How to create a new table in oracle?
How to use "if" statements on multiple conditions?
Can sub procedure/function be called recursively?
What is recovery manager(rman) backup in Oracle?