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 raid, and how it can influence database performance?

1097

---

What is data source object?

1064

---

What are different types of statement?

1081

---

What is use of @@ spid in sql server?

1264

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

1003

---

How to get a list all databases on the sql server?

1155

---

What is a transact-sql statement batch in ms sql server?

1068

---

What is a join in sql? What are the types of joins?

1184

---

What does the on update no action do?

1075

---

How to attach adventureworkslt physical files to the server?

1160

---

How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?

1165

---

What is the downside of using udf?

1157

---

Tell me about builtinadministrator?

1041

---

How to integrate the ssrs reports in application?

1039

---

What is the difference between left and right outer join?

1110

---