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
- 15815 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / jayabharathi
Select empname,salary from emp where salary=(select
max(salary) from emp)
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
Can we deploy SSRS reports on our personal website?
What is the sql server agent?
What is a covering index?
When would you use sql joins?
What is the purpose of floor function?
What does dml stand for?
Difference between 2NF &3NF ?
What is TDS(Tabular Data Stream) Gateway?
How can windows applications connect to sql servers via odbc?
Explain various On-Delete options in a DB table. Which is the default option?
What to check if a User database is locked?
What are the new scripting capabilities of ssms? : sql server management studio
What does it mean to be in union?
What extended events?
Explain indexed views and partitioned view with their syntax.
