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
- 13441 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / swathi
I have just mentioned that 4-5....but ingeneral when you
donno how many employees are there with highly paid
amount...then how are you going to write the query
| Is This Answer Correct ? | 0 Yes | 2 No |
Post New Answer View All Answers
What is Service Broker in sql server 2012?
What will be query used to get the list of triggers in a database?
What is the difference between online clustering and Offline clustering?
What is the maximum size of a row in sql server?
Explain isolation levels that sql server supports?
What is the server name in sql server?
What is the purpose of sql profiler in sql server? : sql server database administration
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is the difference between MVC and Teir Architecher? Plz explain with Layyered Programming example...? Thanks
what are the steps you will take to improve performance of a poor performing query? : Sql server database administration
Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?
What is the difference between for xml raw and for xml auto?
Explain about builtinadministrator?
What is collation sensitivity?
What is database isolation in sql server? : sql server database administration
