Find out the 3rd highest salary?
Answer Posted / srikanth
select q.sal
from emp q
where 3=(select distinct(count(b.sal))
from emp b
where q.sal<=b.sal)
Is This Answer Correct ? | 17 Yes | 10 No |
Post New Answer View All Answers
Differentiate between pl/sql and sql?
Why indexing is needed?
How do we use distinct statement? What is its use?
write an sql query to get third maximum salary of an employee from a table named employee_table. : Sql dba
What is trigger price?
If the application is running very slow? At what points you need to go about the database in order to improve the performance?
How do I count rows in sql query?
What is AUTH_ID and AUTH_USER in pl/sql ?
What does stand for in sql?
What is cte sql?
How do I run pl sql in sql developer?
What is sql character function?
How to check if a column is nullable before setting to nullable?
Why is normalization important?
how do you control the max size of a heap table? : Sql dba