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
- 16212 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
What is sql service broker?
Explain syntax for viewing, dropping and disabling triggers?
What is the need for group functions in sql?
Why normalization is used?
How to check status of stored procedure in sql server?
What is the index requirement in SQL Azure?
How to provide column names in insert statements in ms sql server?
List the different normalization forms?
What is the difference between count and distinct count?
What is the most common type of join?
Define Business Edition in SQL Azure?
How to select some specific columns from a table in a query in ms sql server?
What are dml triggers and types of dml triggers?
Data table as parameter in sql server?
What program is used to store the data source file?
