Find out the 3rd highest salary?
Answer Posted / sachin
select distinct(sal) from employee order by sal desc limit 2,1;
Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a database? Explain
What are the advantages of pl sql?
How do I start pl sql?
How do you concatenate in sql?
explain commit and rollback in mysql : sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
How do you use collections in procedure to return the resultset?
What are sql constraints?
What are the various levels of constraints?
What is sql integrity?
What is clause in sql?
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What do we need to check in database testing?
What are the various restrictions imposed on view in terms of dml?
How to sort the rows in sql.