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
- 16440 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / raju
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
explain different types of cursors? : Sql server database administration
Tell me what do you mean by an execution plan? Why is it used? How would you view it?
Difference between report and query parameter.
What is the purpose of object explorer and its features? : sql server management studio
Your company has 50 branches all over the country all the branches, including the head office have sql server as the database every night all 50 branches upload certain information to the head office which replication topology is best suited for the above scenario?
What is multi-statement table-value user-defined function?
What is use of dbcc commands?
What is self join in sql server joins?
What is the difference between getdate and sysdatetime?
What is candidate key with example?
What are the differences between “row_number()”, “rank()” and “dense_rank()”?
What is ms sql server index?
How to defragment indexes with alter index ... Reorganize?
How does using a separate hard drive for several database objects improves performance right away?
how can a database be repaired? : Sql server administration
