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
- 16431 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 is the temp table?
What is BCP? When does it used in sql server 2012?
What is server-level principal?
What are subqueries in sql server? Explain its properties.
What is the current limitation of the size of SQL Azure DB?
Explain about temporary stored procedure?
What are the basic functions for master, msdb, model, tempdb databases?
How each E-R model constructs can be mapped to the relational model?
which backup strategy you are following at ur company
What is trigger and different types of Triggers?
How to count duplicated values in a column in ms sql server?
What is it unwise to create wide clustered index keys?
What is the difference between a stored procedure and a user defined function?
How do you check sql server is up and running?
Explain in brief how sql server enhances scalability of the database system?
