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
- 68347 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
Describe the left outer join & right outer join. : sql server database administration
What are the properties of sub-query?
i have made a project i vb.net n created a .exe of it after installing it in to any pc, the database (sql express) is not geting accesed i.e the aplication cuts the link of the database, so plz help in this matter.
what is bit datatype? : Sql server database administration
What is the difference between createstatement and preparedstatement?
What is difference between inner join and full join?
How to loop through returning rows?
Can you explain powershell included in sql server 2008?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
Why is the need for data conversion transformations?
How to retrieve error messages using odbc_errormsg()?
Define indexes?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
What is difference between order by and group by?
What are ddl (data definition language) statements for tables in ms sql server?
