Write a query to get all details of employee who has maximum
salary from employee table
Answers were Sorted based on User's Feedback
Answer / krishh
SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);
Is This Answer Correct ? | 23 Yes | 4 No |
Answer / vineet
Select * from EMP_TAB where salary = (select max(salary) from EMP_TAB;
Is This Answer Correct ? | 8 Yes | 1 No |
select max(sal) from emp it will show max sal of
Is This Answer Correct ? | 4 Yes | 1 No |
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 |
Answer / sureshramsing
select * from(select e.* from emp e order by sal desc) where rownum=1;
Is This Answer Correct ? | 2 Yes | 1 No |
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 |
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 |
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 |
What is 'Join' and explain its various types.
we have emp table like Ename,EDOJ,EDOB with Column structure.but we want to know the employee Age.How? Any Body Plz
Which are the new data types introduced in sql server 2008?
What is the difference between locking and multi-versioning?
Which index created when Create Index on table(col), Why
Can you move the resources after pausing the node? : sql server database administration
Difference between: - Delete & Truncate - Table & View - Constraints & Triggers
What are differences in between sql server 2012 and sql server 2016?
What are data resources?
how we can use a database with php.
Can primary key be null?
Explain activity monitors