Write a query to get all details of employee who has maximum
salary from employee table
Answer Posted / krishh
SELECT max(salary) FROM Employee WHERE salary NOT IN (SELECT max(salary) FROM Employee);
| Is This Answer Correct ? | 23 Yes | 4 No |
Post New Answer View All Answers
What is database black box testing?
Explain different types of self contained sub query?
I applied Transactional with updatable subscriptions replication on 2 tables now i want to delete those 2 tables but i cannot delete those tables as replication is running how can i stop replication for those 2 tables(but i don't want to delete those replicated tables but i need to stop the replication) how can i do that
Write the SQL query to drop, truncate and delete table.
Why main is user defined function?
Explain few of the new features of sql server 2008 management studio
What are the recovery models for a database?
What is dbcc command in sql server?
How do I edit a procedure in sql server?
List the different index configurations possible for a table?
What is difference between equi join and natural join?
Can we use custom code in ssrs?
Explain what is the use of custom fields in report?
How to set database to be read_only in ms sql server?
What is 3nf normalization form?