Answer / arshi

SELECT MAX(Salary) AS Expr1
FROM TableName
WHERE (Salary NOT IN
(SELECT TOP (4) MAX(Salary)
AS Expr1
FROM TableName AS
TableName_1
GROUP BY Salary
ORDER BY SalaryDESC))

Answer / ramesh

select top 1 salary

(select distinct top 5

salary from employees

order by salary desc)

a order by salary

Answer / sujit

Hop it helps!

Select sal from (select sal from emp order by sal desc
where rownum<6);

Answer / payal

select salary from emp order by salary desc limit 4,1

Answer / aravind

select * from (select sal from emp order by desc) emp where
rownum = 5

Answer / p.chella vijaya

select top 5 (salary) from emp order by desc

Answer / p.chella vijaya

select top 5 (salary) from emp order by salary desc

Difference between sql and mysql?

0 Answers  

Source File: Target EMPNO, SAL Empno, Format 101, 1000 101, 1000 101, 1100 101, 1000, 1100 101, 1000 101, 1000, 1100, 1000 101, 10000 101, 1000, 1100, 1000, 10000 102, 1100 102, 1100 102, 1300 102, 1100, 1300 102, 1200 102, 1100, 1300, 1200 102, 1500 102, 1100, 1300, 1200, 1500 How can i get that output using datastage(ETL) tool

0 Answers   Miracle Software,

issues involved in modeling and building data werahouses

0 Answers  

What are the three types of anomalies in database and Explain?

9 Answers  

Which three commands cause a transaction to end?

0 Answers   3i Infotech,

What is the default identifier of structure in C?

3 Answers   CybAge,

Does aggregate and fact tables gets populated from transactional data with only diffrence in there granularity? Please clarify?

1 Answers  

Is database a hardware or software?

0 Answers  

What is the relationship that exists inside in E-R diagram?

0 Answers   CGI,

Which is the best graph database?

0 Answers  

a __________ is a virtual table made up of subset of actual table

2 Answers  

Please post the scenerois for writing the complex sql queries , for my practice.Can be any query if you cannot solve.

0 Answers