Find out the 3rd highest salary?
Answer Posted / divya c
Select max(sal) from emp
where sal<(select max(sal) from emp where sal<(select max
(sal) from emp));
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you pronounce sql?
what are dynamic queries in t-sql? : Transact sql
How will you distinguish a global variable with a local variable in pl/sql?
What is t sql used for?
How do you concatenate in sql?
Which are the different character-manipulation functions in sql?
table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is cursor in pl sql with examples?
What is not in sql?
What is pl sql script?
explain the difference between bool, tinyint and bit. : Sql dba
What are the parts of a sql statement?
What is latest version of sql?
What is synchronized subquery?
how can we take a backup of a mysql table and how can we restore it. ? : Sql dba