Interested to Buy Any Domain ? << Click Here >> for more details...
HOW TO FIND THE EMPLOYEE DETAILS WHO ARE GETTING SAME SALARY
IN EMP TABLE
- 18 Answers
- 68953 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / sunil
SELECT * FROM EMP WHERE (SAL IN (SELECT sal
FROM emp GROUP BY sal HAVING COUNT(sal) > 1))
| Is This Answer Correct ? | 72 Yes | 16 No |
Post New Answer View All Answers
What are the steps to take to improve performance of a poor performing query? : sql server database administration
What is the difference between upgrade and migration in sql server?
Can I use sql azure as a backup with log shipping or database mirroring?
What is transaction server explicit transaction?
What is the query and subquery?
What are the common performance issues in sql server?
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is use of except clause? How it differs from not in clause?
What is scd (slowly changing dimension)? : sql server analysis services, ssas
How to use "begin ... End" statement structures in ms sql server?
Do you know what are acid properties?
What is dbcc?
In case you have filters in your report, when filters will be applied in cached report instance?
Why do you need a sql server?
What is parameterized reports in ssrs ?
