Answer / ganesh prasad

all are not working properly incase repeat salary
this one is correct to finding 4th highest salary try run
your system then call me 9438183722

select min(deptsal) from dept where deptsal in ( select
distinct top 4 deptsal from dept order by deptsal desc)

Answer / sysdomain

'top' will fetch only top most : ie top 5 means it will
fetch first 5 rec. After fetching rec only 'order by' is
done ie sorting is done after fetching. therefore using
'top' and 'order by' alone wont get max or min value. for
that we have to use 'distinct' before 'top' (which will sort
the records before fetching).

select top 1 salary from employee where salary in (select
distinct
top n salary from employee order by salary desc)

Answer / saurabh

select max(salary) from Employee where salary not in (
select top 5 Salary from ( select distinct Salary from
Employee order by Salary desc))

Answer / vijay dev arya

select salary from employee where salary>(select max
(salary) from employee)

Answer / smitam

select top 1 salary from emp where (salary<(select max
(salary) from emp ))ORDER BY salary DESC

Answer / vijay

select top 1 sal
from
(select top 3 sal
from emp
order by sal desc )sub
order by sal

Answer / suhail qaiser

SELECT TOP Nth salary
FROM (
SELECT TOP N salary
FROM emp
ORDER BY salary DESC
) TmpTable
ORDER BY salary ASC

Answer / pandian

select top 1 salary from (select distinct top 9 salary from
EmpMaster order by salary desc)a

Answer / kavitha. r

select top 1 salary from employee where salary in (select
top n salary from employee order by salary desc) order by
salary desc

Answer / mayur

DECLARE @SQL VARCHAR(2000), @N INT
SET @N = 5
SET @N = @N - 1

SET @sql = 'select top 1 salary from ABC where salary not
in ( SELECT TOP ' + CAST(@n AS VARCHAR(100)) + ' salary
FROM ABC ) '

SELECT @SQL

EXEC (@SQL)

Explain SELF JOIN ?

3 Answers   ADP,

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

if you encounter this kind of an error message, what you need to look into to solve this problem? : Sql server database administration

0 Answers  

Describe in brief databases and sql server databases architecture.

0 Answers  

What is transact-sql ddl trigger?

0 Answers  

How can I create a plain-text flat file from SQL Server as input to another application?

2 Answers  

How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?

0 Answers  

Explain cdc and sql injection?

0 Answers  

What is the order in which the SQL query is executed? list them in order.

5 Answers   CarrizalSoft Technologies, CTS, Oracle,

Differentiate between ms sql server reporting services vs crystal reports?

0 Answers  

How to select some specific columns from a table in a query in ms sql server?

0 Answers  

plz tell me the new features of sqlserver2000,sqlserver2002,sqlserver2005

3 Answers