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
Explain what are synonyms used for?
How to generate query output in html format?
How to increment dates by 1 in oracle?
What are a query and state the different types of queries and their uses?
Database crashes. Corruption is found scattered among the file system neither of your doing nor of Oracles. What database recovery options are available? Database is in archive log mode.
What is data file?
What is the data type of dual table?
How to create a stored procedure in oracle?
What happens in oracle commit?
Is java required for oracle client?
What is a view and how is it different from a table?
Explain a segment?
How to insert multiple rows with one insert statement in oracle?
In XIR2 if we lost the administration password .How can we regain the password?thanks in advance.
How to define an external table with a text file?