find out the third highest salary?
Answer Posted / mohd. rashid
SELECT TOP 1 salary
FROM(
SELECT DISTINCT TOP 3 salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What are the differences between blob and clob in oracle?
How to rename an existing table?
What is oracle and what are its different editions?
How to create a new table by selecting rows from another table?
Does oracle charge for java?
In Oracle Clinical 4.5.0, can the VIEW_TEMPLATE_ID column in DATA_EXTRACT_VIEWS table contain NULL value?
what is the dual table in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
please explain.. DB architecture ...
ur a sql devoloper...what is the process in ur company for finding the database BUGS .. seperate DB testers are there? or devr.s are manage? if DB TESTERS in there what is the process
What is the implicit cursor in oracle?
What happens if you set the sga too low in oracle?
query optmization techniques and quwry analyser+projects+ppts
How do I connect to oracle database?
Please explain oracle data types with examples?