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
- 16186 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / kalyan
select name,max(sal) from emp group by name
| Is This Answer Correct ? | 6 Yes | 8 No |
Post New Answer View All Answers
Which is the latest version of sql server and when it is released?
What is a virtual table in sql?
What functions can a view be used to performed?
What is bcnf normalization form?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
How would you choose between a clustered and a non-clustered index?
Tell me what is log shipping?
Tell me what is difference between clustered and non clustered index?
What is “asynchronous” communication in sql server service broker?
What is normalization and its types?
How to check if stored procedure is running in sql server?
How to check table values in sql server?
Describe the left outer join & right outer join. : sql server database administration
What is data source object?
Is BCNF better than 2NF & 3NF? Why?
