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 / 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 are the characteristics of modern DBMS?
what are user defined datatypes? : Sql server database administration
Explain about Normalization?
What is a select query statement in ms sql server?
Define tool Manage Statistics in SQL Server 2000 query ?
How to delete duplicate rows?
How to select true false based on column value in sql server?
What is stored in the mssqlsystemresource database? : sql server database administration
What is clustered primary key?
Using the customer, and order table in northwind database, please write a query to produce xml?
What are the differences between user defined functions and stored procedures?
Does sql server 2000 clustering support load balancing?
What is a scheduled job or what is a scheduled task?
How data can be copied from one table to another table?
What is the difference between for xml raw and for xml auto?