Find out the 3rd highest salary?
Answer Posted / a.jyothsna
select a.sal
from emp a
where 3=(select distinct(count(b.sal))
from emp b
where a.sal<=b.sal)
Is This Answer Correct ? | 100 Yes | 45 No |
Post New Answer View All Answers
Does user triggers have entry for trigger with compilation errors?
What does data normalization mean?
How does cross join work in sql?
What does truncate mean in sql?
What are sql injection vulnerabilities?
What is the difference between view and stored procedure?
Which normal form is best?
How do I count rows in sql?
What is exception? What are the types of exceptions?
What is a recursive stored procedure?
How do temporal tables work?
What is a trigger word?
What is equi join in sql?
Why do we use set serveroutput on?
Which is faster union or join?