HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
Answer Posted / dilip
SELECT * FROM EMP WHERE (SAL = (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))
Is This Answer Correct ? | 28 Yes | 24 No |
Post New Answer View All Answers
Define a cross join?
What is the latest version of microsoft sql server?
Suppose we have a table "MyTable" containing 10 rows, what query should be executed to update the odd rows "Salary" as 9000?
Can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible?
What is transaction server auto commit?
What is the difference between composite index and covering index?
Explain what is the main purpose of having conversation group?
Write an SQL query to obtain the 2nd highest salary.
How to use values from other tables in update statements in ms sql server?
Suppose you want to implement the following relationships while designing tables. How would you do it?a.) One-to-oneb.) One-to-manyc.) Many-to-many
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What do you mean by normalisation?
How can you insert values in multiple rows using one Insert statement?
What are the tables in sql?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration