Interested to Buy Any Domain ? << Click Here >> for more details...
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).
- 9 Answers
- 16179 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / kishore kumar
Select ename from emp where sal=(select max(sal) from emp)
| Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
What are different types of statement?
Differentiate between a having clause and a where clause.
How to add additional conditions in SQL?
What is it unwise to create wide clustered index keys?
what is a correlated sub-query? : Sql server database administration
Define ACID properties in a Database?
can any body tell me how to know the password of current user in sql server
List out the differences between global and local temp tables in sql server?
Define full outer join in sql server joins?
What is unpivot?
What is difference between views and tables?
When would you use the stored procedures or functions?
How to create an identity column?
What are the advantages of log shipping?
What is difference between clustered index and non clustered index?
