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
how can you find out if the current user is a member of the specified microsoft® windows nt® group or microsoft sql server™ role? : Sql server administration
How retrieve field names from the table in SQL through JAVA code?
What are the restrictions applicable while creating views? : SQL Server Architecture
How many joins in sql server?
What are the advantages of policy management?
What is the difference in accessing db between sql server vs sql azure?
What are the steps to process a single select statement?
Explain the difference between primary keys and foreign keys?
What is snapshot replication?
What are the tools available in market as an alternative to sql server reporting services?
Explain the categories of stored procedure i.e. System stored procedure, local stored procedure, temporary stored procedure, extended stored procedure, remote stored procedure?
How do I start sql server 2016?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are the disadvantages of using the stored procedures?
What are the differences between having and where clause.