An employee table, with the columns id, name, sal and dob.
Query to select emp names of all highest salaries(there are
4-5 people having the same salary which happens to be the
highest).
Answers were Sorted based on User's Feedback
Answer / amol dhane
Select * From (Select emp1.*, dense_rank () Over (Order By
sal asc) Salary_Order From employee emp1)emp2 Where
Salary_Order = 1
Is This Answer Correct ? | 10 Yes | 1 No |
Answer / kishore kumar
Select ename from emp where sal=(select max(sal) from emp)
Is This Answer Correct ? | 13 Yes | 5 No |
Answer / jayabharathi
Select empname,salary from emp where salary=(select
max(salary) from emp)
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / reshu singhal
select name from employee where sal = (select max(sal) from
employee)
Is This Answer Correct ? | 4 Yes | 1 No |
Answer / subrata sinha roy
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
Is This Answer Correct ? | 4 Yes | 2 No |
Answer / anil
select name,sal from employee where sal in(select top 5 sal from employee order by sal desc)
Is This Answer Correct ? | 7 Yes | 7 No |
Answer / raju
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
Is This Answer Correct ? | 0 Yes | 0 No |
What are points to remember while using the fillfactor argument?
what are different types of backups available in sql server? : Sql server database administration
What is the difference between having and where clause?
What do you understand by recursive stored procedures?
How to swap the data of two columns in a table. both the columns containing varchar values.
How can I create a new template for import ? : sql server management studio
Which tcp/ip port does sql server run on? How can it be changed?
How to test values returned by a subquery with the in operator?
What is sqlcmd?
How to modify existing triggers using "alter trigger"?
What is difference between stored procedure and user defined function?
can any one please send sql quries most used in applications.