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 |
Do you know what is lock escalation?
What is service broker?
from the table display the 2nd highest salary? and also the least 2nd salay?
How to link up the text file to a Database table?
What do you understand by sql server agent?
What is dirty page?
How to download and install sql server 2005 books online?
What do you mean by an execution plan? How would you view it?
Ek lifafa 10 noto se bhara hai usme 2 or 5 ke note nahi hai aur usme total 50Rs hai, to batao lifafe me kon se not kitne hia it’s a challenge thank’s
What are the grouping functions?
what is normalization? Explain different levels of normalization? : Sql server database administration
create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration