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
- 13426 Views
- ADP, I also Faced
- E-Mail Answers
Answer Posted / kishore kumar
Select ename from emp where sal=(select max(sal) from emp)
| Is This Answer Correct ? | 13 Yes | 5 No |
Post New Answer View All Answers
What are the pre-defined functions in the sql server?
What happens if null values are involved in bitwise operations?
What is the use of set nocount on/off statement?
How important do you consider cursors or while loops for a transactional database?
What it means to be triggered?
Tell me what are the advantages of using stored procedures?
What is 'Join' and explain its various types.
Explain features and concepts of analysis services?
What is the sql server 2000 version number?
whats the maximum size of view state??
What are acid properties of transaction?
What is intellisense?
What are the different types of columns types constraints in the sql server?
What is the status of services on passive node for failover cluster in sql server? : sql server database administration
What is a trigger and its types?
