write a query for the fifth highest salary?
Answers were Sorted based on User's Feedback
Answer / venkates
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
| Is This Answer Correct ? | 22 Yes | 2 No |
Answer / nitin bisht
SELECT empSalary FROM empTable e1 WHERE (5 = (SELECT
COUNT(DISTINCT (e2.empSalary))
FROM empTable e2 WHERE e2.empSalary >= e1.empSalary))
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / piyush gupta
select distinct(a.sal) from emp a where 5=(select
count(distinct(b.sal)) from emp b where a.sal<=b.sal)
you can this query for nth highest salary
replace 5 with any number
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / prasanna
select max(sal) from emp where sal not in (select Top 4 sal
from emp order by sal desc)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / shahid
select *from(select sal,rank() over(order by sal desc)as sal_rank from emp) where sal_rank=5;
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / bhramar
select top 1 Sal from(select distinct top 5 Sal from TestEmp order by Sal desc) a order by Sal
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / suparna
select salary from employee e where 4=(select count(*) from
emp f where e.sal<f.sal)
| Is This Answer Correct ? | 8 Yes | 8 No |
Answer / chethan
select Salary from ( select salary from emp order by desc) as employee where rownum = 5;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / bezalel
select salamt from
(
select rownum n,salamt from
(
select distinct salamt from emp order by salamt desc
)
)
where n=5
| Is This Answer Correct ? | 0 Yes | 0 No |
How does non-cluster index functions?
hai if any one having any project sample table structure please froward to my mail id tauseefwst@yahoo.com
How does database replication work?
How is image stored in database?
Can you tell any two advantages of stored procedures?
Does facebook use graph database?
Can you create a database in word?
Explain artificial key?
if we have set auto differencial back up then waht is difference between 1.appen to media 2.over right the existing media
1 Answers Indian Web Technology,
What are different types of joins used in?
What is a driver in database?
What is database schema name?
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)