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 |
1.How to check the backup file details if we do not have access to that folder 2.how to check the backup file size without connecting to the folder
3 Answers CarrizalSoft Technologies, IBM,
How do you manipulate data?
What is wide table?
Why I am getting this error when dropping a database in ms sql server?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
Please give me the SP for the below scenario. I have two tables named Table1 and Table2...I need to fetch record by record from Table1 and insert the record in to table2 where the value in the sno column of the table1 is even number.
What is difference between Triggers and store procedure?
What are the different types of upgrades that can be performed in sql server?
What are the two virtual tables SQL Server maintains for triggers?
How to delete duplicate rows?
How to how to convert numeric expression data types using the convert() function??
if 3 duplicate records in table,i want to delete 2 alternating duplicate records by keeping 1 duplicate and 1 original as it is,how?