write the query for find the top 2 highest salary in sql
server
Answers were Sorted based on User's Feedback
Answer / arun kumar k s
select Distinct Top 2 Salary from EMP order by Salary desc
Is This Answer Correct ? | 111 Yes | 59 No |
Answer / naren
select max(salary) as salary1 from employee where salary <
select max(salary) as salary2 from employee
Is This Answer Correct ? | 27 Yes | 16 No |
Answer / raja.p
Find The 4 Top Salary in a Company
----------------------------------
CREATE TABLE EMPLOYEE2 (NAME VARCHAR2(20), SALARY NUMBER) ;
CREATE TABLE employee2 (
name char(20),
salary float);
INSERT INTO employee2 VALUES (
'Raja',
10000);
INSERT INTO employee2 VALUES (
'Arithas',
10000);
INSERT INTO employee2 VALUES (
'Balaji',
12000);
INSERT INTO employee2 VALUES (
'Vairam',
13000);
INSERT INTO employee2 VALUES (
'Muthu Krishnan',
14000);
INSERT INTO employee2 VALUES (
'Muthu Kumar',
15000);
INSERT INTO employee2 VALUES (
'Ramesh',
9000);
select e.name,e.salary from Employee2 e where 4>(select
count(Distinct
d.salary)from employee2 d where d.salary>e.salary) order by
e.salary desc;
Is This Answer Correct ? | 16 Yes | 8 No |
Answer / ranjeet kumar shrivastava
select * from tbl_htl_cntry e where 2>=(select
count(distinct salary) from tbl_htl_cntry where
e.salary<=salary)
it is aslo working syntax.
ranjeetvasu@rediffmail.com
Is This Answer Correct ? | 10 Yes | 3 No |
select top 2 salary from emp order by salary desc
Is This Answer Correct ? | 38 Yes | 32 No |
or if u want 2nd highest then write this query
select Top 1 salary from ( select top 2 salary from
emp_table order by salary desc)temptable order by salary
asc.
Is This Answer Correct ? | 29 Yes | 24 No |
Answer / 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 |
Answer / srinivas
select e1.sal from emp e1 where 2=(select count(distnct
(e2.sal) from emp e2 where e2.sal>=e1.sal)
Is This Answer Correct ? | 33 Yes | 32 No |
Answer / saravanan p
select distinct top 2 salary from employee order by salary
desc
Is This Answer Correct ? | 6 Yes | 5 No |
What is difference between rollback immediate and with no_wait during alter database?
What are the lambda triggers?
Which are new data types introduced in sql server 2008?
How will you hide an attribute? : sql server analysis services, ssas
What is WITH CHECK OPTION
3 Answers Karur Vysya Bank KVB,
What is recompile sql server?
How to resolve the orphan use problem? : sql server security
What is bcp? When does it used?
What are the types of table?
What is change tracking in sql server?
What is sub query and its properties?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?