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
- 68344 Views
- Infosys, TCS, I also Faced
- E-Mail Answers
Answer Posted / asit
Can someone answer to this. on below query where i want to find same salary in employee table,
SELECT * FROM EMPLOYEE WHERE (SAL IN (SELECT sal FROM empLOYEE GROUP BY sal HAVING COUNT(sal) > 1))
i am getting correct output.
but if i change it to 'COUNT(SAL)>=1' then it prints all the lines from the table.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is subquery in sql?
What is 2nf normalization?
what is the Ticketing tool used in Wipro technologies at Bangalore...???
Define Business Edition in SQL Azure?
How do I partition a table in sql server?
Explain system functions or built-in functions? What are different types of system functions?
What are the security related catalog views? : sql server security
What is usually the first word in a sql query?
Why transaction is important?
It is important form e to get the information from log files of applications executed by the task scheduler? Does sql studio save these log files? : sql server management studio
what is database replication? : Sql server database administration
what is difference between NULL and ISNULL in SQL Server 2008?
What is a matrix in ssrs?
Do you know nested transaction?
What are the kinds of subquery?
