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 are locks in sql?

979

---

When would you use a before or after trigger?

907

---

What are the benefits of normalization?

1109

---

Which is the best place or learning center for MS SQL?????In Bangladesh?????

2075

---

Mention the 3 ways to get a count of the number of records in a table.

977

---

What is a functions and types in sql server?

1087

---

Write a sql query to sort on different column name according to the parameters passed in the function?

904

---

Differentiate between mongodb vs. Sql server?

1095

---

What is read committed?

1084

---

What is the difference between a view and a stored procedure?

1037

---

How do I find sql server instance name?

959

---

How to set the current database in ms sql server?

1081

---

What are the different normalization forms?

1110

---

Do you know concepts and capabilities of sql server?

1059

---

What is self contained scalar sub query?

974

---