Interested to Buy Any Domain ? << Click Here >> for more details...
write the query for find the top 2 highest salary in sql
server
- 36 Answers
- 75155 Views
- Cranes, Jayanti Software, Medi Assist, Rmax, TCS, I also Faced
- E-Mail Answers
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
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
What happens if date-only values are provided as date and time literals?
How can we get count of the number of records in a table?
What is 1nf 2nf and 3nf?
How to delete database objects with "drop" statements in ms sql server?
What is the New in SQL server 2008?
Explain transaction server implicit?
What is the default sql server instance name?
What is co-related sub query?
What are the properties of primary key?
List out the differences between the clustered index and non-clustered index in sql server?
What do you understand by the denormalisation?
What are drillthrough reports?
What is a hint?
What is transaction server implicit?
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
