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 sql and its types?
What does closing a cursor do?
Explain the difference in execution of triggers and stored procedures?
what are the nonstandard string types? : Sql dba
How do you declare a variable in pl sql?
what are different types of collation sensitivity? : Sql dba
Is not equal in sql?
Is sqlite thread safe?
What is relationship? How many types of relationship are there?
Can we write ddl statements in functions?
How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?
What are the most important characteristics of pl/sql?
What is trigger and how to use it in sql?
What is parallel hint?
What is trigger explain it?