Interested to Buy Any Domain ? << Click Here >> for more details...
employee table has employee id
-----------
empid
----------------
1
2
3
3
3
4
5
5
5
6
6
6
7
here the values r repeated two times.how to select the
repeated values only.i.e 3,5,6 should alone come.
- 3 Answers
- 7655 Views
- I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
select empid from employee where empid in (select empid
from employee group by empid having count(empid) > 1)
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Can we deploy SSRS reports on our personal website?
Define model database?
Explain about thread and memory management process of SQL?
What is the difference between count and distinct count?
What command would you use to add a column to a table in sql server?
How to delete duplicate rows?
Do you know what are pages and extents? : SQL Server Architecture
What is report server project?
What is filestream?
Explain what is public role in sql server?
As per your opinion what are the five top responsibilities of a dba? : sql server database administration
What is sql server management studio? : sql server management studio
How do I view a script in sql server?
Can group by and orderby be used together?
what is isolation level at dead lock?
