Answer Posted / sums

Step1:
Create the "Salary" table,

Create table Salary
( Design_name varchar(20),
Basic_Sal int)

Step2:
Insert the values into "Salary" table,

Insert into Salary values('Office_Boy',4000)
Go
Insert into Salary values('Clerk',5000)
Go
Insert into Salary values('Head_Clerk',6000)
Go
Insert into Salary values('Accountant',7000)
Go
Insert into Salary values('Manager',8000)
Go
Insert into Salary values('PA',9000)
Go
Insert into Salary values('GM',10000)

Step3:
Write the Query aganist "Salary" table to find 'N'th
Maximum Basic Salary.

Query:

Select * from Salary s1 where (N =(select count(distinct
(s2.Basic_Sal)) from Salary s2
where s2.Basic_Sal>=s1.Basic_Sal))

N=1 --> Finds the first maximum Basic_sal
N=2 --> Finds the second maximum Basic_sal
N=3 --> Finds the Third maximum Basic_sal
.
.
.
N='N'--> Finds the 'N'th maximum Basic_sal

To find '2' maximum:

Select * from Salary s1 where (2=(select count(distinct
(s2.Basic_Sal)) from Salary s2
where s2.Basic_Sal>=s1.Basic_Sal))

Output:

Design_name Basic_sal

PA 9000

What is a recursive stored procedure in sql server?

1097

---

How to create a testing table with test data in ms sql server?

1023

---

Can I save my report as html, excel or word? : sql server management studio

911

---

Explain how would you store your query in an SSRS report or a Database server?

116

---

What is recompile sql server?

995

---

What is data compression?

945

---

How to generate create view script on an existing view?

951

---

what is the difference between count(*) and count(1) ?

1035

---

What is the difference between dataadapter and datareader?

950

---

How to delete a login name in ms sql server?

1012

---

What Are the Main Features of SQL Azure?

115

---

What are drillthrough reports?

144

---

Which are the two editions in which SQL Azure database available?

117

---

How to write character string constants or literals in ms sql server?

965

---

What is use of dbcc commands?

1027

---