Answer / sridhar

select gross_pay from tbl_payroll where gross_pay != (select
max(gross_pay) from tbl_payroll) limit 0,3

Answer / rajeev

select salary-1 from users where salary in (select
max(salary) from users);

Answer / ashish kumar

To find nth maximum salry

Select salary from tbl_name a where
n-1=(Select count(distinct(count(*))) from tbl_name b
where b.salary>a.salary)

Answer / suhail

select top 1 salary from (select top 5 salary from
emp_table order by salary desc)temptable order by salary asc

Answer / gunjan sapra

select top 10 from tbl_name order by salary desc

What is Trace flag?

1 Answers   Wipro,

what is the system function to get the current user's user id? : Sql server database administration

0 Answers  

What happens if null values are involved in comparison operations?

0 Answers  

What is the difference between TRUNCATE and DROP?

0 Answers  

What do you mean by an execution plan? Why is it used?

0 Answers  

How to insert data with null values?

0 Answers  

How to convert numeric expression data types using the cast() function?

0 Answers  

What happens when unicode strings concatenate with non-unicode strings?

0 Answers  

What number sorts of privileges are accessible in sql?

0 Answers  

What is user-defined function?

0 Answers  

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

Can you use order by when defining a view?

0 Answers