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
is mysql query is case sensitive? : Sql dba
What is nested table in pl sql?
Sql technical questions
How to connect a sql*plus session to an oracle server?
What is the difference between row level and statement level trigger?
What is sql catalog?
What are the basic sql commands?
How do you write a subquery?
Explain the select statement in sql?
What is a constraint? Tell me about its various levels.
what are the advantages of using stored procedures? : Sql dba
What type of database is cloud sql?
what is the difference between sql and t-sql? : Transact sql
Is it possible to remove child records without removing master table records...the two having pk,fk relationship?
What is a database? Explain