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 much does sql server 2016 cost?

0 Answers  

what is differencial backup?how to work?Anybody explai it?

2 Answers   HCL,

Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?

0 Answers  

What is SQL Profiler and the use of it?

2 Answers   247Customer,

What is an example of a primary key?

0 Answers  

Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?

0 Answers  

How to edit table in sql server 2017?

0 Answers  

How can you tell if a database object is invalid?

0 Answers   MCN Solutions,

What is the difference between inner join and equi join?

0 Answers  

what is victor class

0 Answers  

Explain transaction server isolation?

0 Answers  

What does <> symbol mean?

0 Answers