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
How do you use a while loop in pl sql?
explain commit and rollback in mysql : sql dba
Can we use having without group by in sql?
how to get help information from the server? : Sql dba
How much does sql cost?
How do you break a loop in pl sql?
how to check myisam tables for errors? : Sql dba
What is string join?
how do you know the version of your mysql server? : Sql dba
What is date functions?
What is offset and limit in sql?
What is mutating error in pl sql?
define data blocks ? : Sql dba
what is recursive stored procedure? : Sql dba
what is a constraint? Tell me about its various levels. : Sql dba