Find out the 3rd highest salary?
Answer Posted / kaushal kassi
select distinct a.sal
from employee a
where 3=(select count(distinct b.sal)
from employee b
where a.sal<=b.sal)
Is This Answer Correct ? | 24 Yes | 12 No |
Post New Answer View All Answers
what is a control file ? : Sql dba
What is sql indexing?
What is the maximum size of sqlite database?
Define a temp table?
What are different types of sql commands?
What is a unique key?
What type of join is sql join?
Why do we use sql constraints?
Why is %isopen always false for an implicit cursor?
What normalization means?
what is sql in mysql? : Sql dba
Why we use stored procedure instead of query?
How do I edit a stored procedure?
Is join and inner join the same?
what are the system privileges that are required by a schema owner (user) to create a trigger on a table?