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

Where the sql logs gets stored?

991

---

How can windows applications connect to sql servers via odbc?

1128

---

Explain different types of self contained sub query?

1047

---

Issues related in upgrading SQL Server 2000 to 2005 / 2008

1890

---

What types of Joins are possible with Sql Server?

1123

---

What Is Rdbms?

1165

---

What is a data collection table?

1012

---

How to insert and update data into a table with "insert" and "update" statements?

988

---

What is PROJECTION Operation?

1027

---

What stored procedure can you use to display the current processes?

896

---

How to use copy and concatenate commands in SQL?

1144

---

What is @@error in sql?

1070

---

Can sql servers link to other servers like oracle?

845

---

What are scheduled tasks in sql server?

1087

---

How to receive output values from stored procedures?

1146

---