find out the third highest salary?
Answer Posted / chanchal
SELECT MIN(salary) FROM Department WHERE salary IN
(SELECT TOP 3 salary FROM Department ORDER BY salary DESC)
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
What is oracle sid?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
State the difference between a primary key and foreign key?
How to save query output to a local file?
How to pass a parameter to a cursor in oracle?
Explain oracle data types with examples?
What do you know about normalization? Explain in detail?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?
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.
How do you store pictures in a database?
What is the difference between a primary key & a unique key?
What do you understand by a database object? Can you list a few of them?
How to load a large xml file?
How to use "in out" parameter properly?