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

How can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role?

0 Answers  

Can you name a few encryption mechanisms in sql server?

0 Answers  

what are the limitations of parameters in a storedprocedure

1 Answers  

Explain the concept of view and Types of views in SQL server?

0 Answers   HCL,

Explain about link server in sql server?

0 Answers  

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

Explain primary key and foreign key constraints?

0 Answers  

what is hash table

3 Answers   ILFS, Teledata,

How to remove duplicate rows from table?

0 Answers  

Write a sql query to delete duplicate records from a table called table1

0 Answers  

How to convert a table data in XML format in sql server?

0 Answers  

What are different types of views?

0 Answers