how to find the second highest salary from emp table?
Answer Posted / adithya
select min(sal) from (select distict sal from emp where
rownum<3 order by sal desc)
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How do you delete data from a table?
what is acid property in database? : Sql dba
Difference between global and parameter variables?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what is the difference between a web-garden and a web-farm? : Sql dba
What is the sql query to display the current date?
Why we use join in sql?
What is relationship? How many types of relationship are there?
Why is pl sql needed?
Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?
What is cross join sql?
What is the most common sql injection tool?
What is a temp table?
What is sql*loader and what is it used for?
How do you pronounce sql?