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).
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
Explain about sql server login?
Give me a SQL Query to find out the second largest company?
What is etl - extraction, transformation, and loading?
How to enter binary string literals in ms sql server?
How will you monitor replication activity and performance? What privilege do you need to use replication monitor? : sql server replication
Do you know what is difference between index seek vs. Index scan?
Why use “pivot” in sql server?
Can You Use A Stored Procedure To Provide Data To An Ssrs Report?
What are indexers?
How is a full-text index updated?
What is purpose of normalization?
What are the functions in sql server?
What is the difference between push and pull subscription? : sql server replication
Where is my database stored on the hard disk in ms sql server?
I have triggers,views,functions,stored Procedures for a table. When I am dropping that table which objects are deleted?