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
- 16437 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
How to use go command in "sqlcmd"?
How to drop an existing schema in ms sql server?
How to modify existing triggers using "alter trigger"?
What is catalog views?
How important do you consider cursors or while loops for a transactional database?
What is CTE in SQL
Give main differences between "Truncate" and "Delete".
What is a table called, if it has neither cluster nor non-cluster index? What is it used for?
What does it mean to invest in the index?
What are the advantages of using stored procedures?
What are the five characteristics of good data?
What do you mean by collation recursive stored procedure?
How to rename an existing column with sql server management studio?
John exports information periodically from a microsoft sql server database to an oracle database what is the best way to do this?
Explain what you mean by 3 tier architecture.
