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 is a join? : Sql server database administration
Explain the properties of the relational tables?
Why are sql functions used?
How can you tell if a database object is invalid?
What is the Difference Between Primary and Foreign Key?
How to copy the tables, schema and views from one sql server to another?
Explain Normalization and DE normalization
What are cursors in ms sql server?
Why use view instead of a table?
You want to use a perspective in an mdx query. How do you select the perspective?
What is the concept of optimization?
What are the differences between DDL, DML and DCL in SQL?
How do I find the query plan in sql server?
What is the chart in report?
What is the function of inner join?