find the third highest salary?
Answers were Sorted based on User's Feedback
Answer / justin
SELECT sal FROM empORDER BY sal DESC LIMIT 2 , 1
| Is This Answer Correct ? | 0 Yes | 2 No |
Answer / purushotham
select level,max(sal)
from table
where level=3
connect by prior sal>sal
group by level
| Is This Answer Correct ? | 0 Yes | 6 No |
Answer / mousumi dalai
select min(sal) from emp where sal in
(select sal from emp order by sal desc where ROWCOUNT <=3) ;
| Is This Answer Correct ? | 9 Yes | 36 No |
hello..... i am an comp science engineering graduate planning to do ORACLE certification in PLSQL 9i. just wanted to know whats the possibility getting job is their openings???? is it worth doin that course n certification
What is function and procedure in pl sql?
How does left join work in sql?
What is not null in sql?
what are the advantages of cursors than procedures?
Is natural join and inner join same?
What is difference between stored procedures and application procedures?
Types of optimization?
What is dense_rank?
What is a call statement? Explain with an example.
Can we write dml inside a function in sql server?
what are all types of user defined functions? : Sql dba
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)