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

What is meant by distributed system?

0 Answers  

can i use the commands "modify" and Change in DB2 to alter my column datatype and its name in a table?

0 Answers  

can any one tell me how i can start database testing mean what should be initial point and how i can write a query for listing page of any item thanks in advance

0 Answers  

Define stored procedure?

0 Answers  

Explain alternate key?

0 Answers  

Explain database partitioning.

0 Answers  

What is ole db source in ssis?

0 Answers  

During insert operation in Netezza Connector, if we give direct option as Yes , is there any issue?

0 Answers  

issues involved in modeling and building data werahouses

0 Answers  

Is it good to store images in database?

0 Answers  

What are the most common databases?

0 Answers  

Explain file manager?

0 Answers