Write a query to get all details of employee who has maximum
salary from employee table

Answers were Sorted based on User's Feedback



Write a query to get all details of employee who has maximum salary from employee table..

Answer / krishh

SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);

Is This Answer Correct ?    23 Yes 4 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / vineet

Select * from EMP_TAB where salary = (select max(salary) from EMP_TAB;

Is This Answer Correct ?    8 Yes 1 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / vineetchauhan

select max(sal) from emp it will show max sal of

Is This Answer Correct ?    4 Yes 1 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / anil kumar prajapati

CREATE TABLE Employee_Test
(
Employee_ID INT,
Employee_name Varchar(100),
Employee_Salary Decimal (10,2)
);
INSERT INTO Employee_Test VALUES (1,'Anish',1000);
INSERT INTO Employee_Test VALUES (2,'Sushant',1200);
INSERT INTO Employee_Test VALUES (3,'Rakesh',1100);
INSERT INTO Employee_Test VALUES (4,'Manoj',1300);
INSERT INTO Employee_Test VALUES (5,'Amit',1400);
INSERT INTO Employee_Test VALUES (6,'Lokesh',1600);
INSERT INTO Employee_Test VALUES (7,'Maneneder',1400);
INSERT INTO Employee_Test VALUES (8,'Narendra',400);
INSERT INTO Employee_Test VALUES (9,'Kaushal',1900);
INSERT INTO Employee_Test VALUES (10,'Vikas',3400);
INSERT INTO Employee_Test VALUES (11,'Sudhir',800);
SELECT *FROM Employee_Test Emp1
WHERE ( n ) = (SELECT COUNT( DISTINCT (Emp2.Employee_Salary
) )
FROM Employee_Test Emp
WHERE Emp2.Employee_Salary >= Emp1.Employee_Salary
)

Is This Answer Correct ?    6 Yes 4 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / sureshramsing

select * from(select e.* from emp e order by sal desc) where rownum=1;

Is This Answer Correct ?    2 Yes 1 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / vj

with cte as
(
select row_number() over (order by employee_salary desc)
maxSal ,* from Employee_Test)
select * from cte where maxSal=1

Is This Answer Correct ?    1 Yes 1 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / mithilesh gatole

Answer -

SELECT FROM Employee Emp1 WHERE (N-1) = ( SELECT COUNT(DISTINCT(Emp2.Salary)) FROM Employee Emp2
WHERE Emp2.Salary > Emp1.Salary)

Is This Answer Correct ?    0 Yes 1 No

Write a query to get all details of employee who has maximum salary from employee table..

Answer / sureshramsing

select * from emp where (empno,1)=(select * from(select empno,row_number() over(order by sal desc) rn from emp) where rn=1);

Is This Answer Correct ?    0 Yes 4 No

Post New Answer

More SQL Server Interview Questions

What is 'Join' and explain its various types.

0 Answers   Genpact,


we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz

6 Answers  


Which are the new data types introduced in sql server 2008?

0 Answers  


What is the difference between locking and multi-versioning?

0 Answers  


Which index created when Create Index on table(col), Why

2 Answers   CGI,






Can you move the resources after pausing the node? : sql server database administration

0 Answers  


Difference between: - Delete & Truncate - Table & View - Constraints & Triggers

1 Answers   United Healthcare,


What are differences in between sql server 2012 and sql server 2016?

0 Answers  


What are data resources?

0 Answers  


how we can use a database with php.

2 Answers   HCL, IT Solution,


Can primary key be null?

0 Answers  


Explain activity monitors

0 Answers  


Categories