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 window functions in sql server?

1004

---

What are tables in sql server?

1030

---

What is the importance of three tier architecture?

1086

---

Can you explain different types of joins?

932

---

can a table be moved to different filegroup? : Sql server administration

968

---

What are the differences between union, intersect, and minus operators?

1082

---

how many type of indexing in database?

976

---

What are examples of triggers?

1086

---

tell me what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

1018

---

What are four major operators that can be used to combine conditions on a where clause?

1039

---

Differentiate between ms sql server reporting services vs crystal reports?

896

---

Write the syntax for stuff function in an sql server?

1024

---

What do you mean by an execution plan? How would you view it?

912

---

How to name query output columns in ms sql server?

962

---

What are partitioned views?

985

---