find out the third highest salary?
Answer Posted / sapna rawal
SELECT TOP 1 salary
FROM (
SELECT DISTINCT TOP n salary
FROM employee
ORDER BY salary DESC)
ORDER BY salary ;
n=3.In this case.
| Is This Answer Correct ? | 1 Yes | 5 No |
Post New Answer View All Answers
Explain overloading. Can functions be overloaded?
Please explain me all types of Data models. Also give me the details if each model can have other name.for example:schematic data model is also known as conceptual data model and entity relation data model.
Can group functions be mixed with non-group selection fields?
What is set verify off in oracle?
Compare and contrast between sql and sql server and explain its various functions?
Her departmandaki isçilerden empno' su ikinci sirada olan isçilerin empno, deptno, hiredate, sira_no bigilerini döndüren sorguyu yaziniz?
How to convert raw data type into text in oracle? Explain
What is tns entry?
Where do you use decode and case statements?
Explain oracle left join with an example?
How to update a table row with a record?
What is the fastest query method to fetch data from the table?
What is a tns service name?
How does Oracle guarantee data integrity of data changes?
How to get a list of all user accounts in the database?