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
- 16201 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / subrata sinha roy
SELECT NAME ,SAL FROM employee WHERE
SAL=(SELECT MAX(sal)from employee )
| Is This Answer Correct ? | 4 Yes | 2 No |
Post New Answer View All Answers
Is foreign key a primary key?
Why is there a performance difference between two similar queries where one uses union and the other uses union all?
How do I schedule a sql server profiler trace?
What is use of except clause? How it differs from not in clause?
Please explain the characteristics of a transaction server for example atomicity, consistency, isolation, durability?
How can we use ConnectorJ JDBC Driver with MS SQL?
How to store and query spatial data?
What are the types of sql server?
How can you set the threshold at which sql server will generate keysets asynchronously?
What are the advantages to use stored procedures?
Explain in details security in SQL azure?
How to automatically create a log when an exception is being received into SQL Server?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What happens if null values are involved in bitwise operations?
How do I get to sql server configuration manager?
