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
- 7811 Views
- I also Faced
- E-Mail Answers
Answer Posted / meher
If you want to get the count for the duplicates then, the
query will be:
SELECT EMPID,COUNT(EMPID) FROM EMPLOYEE GROUP BY EMPID
HAVING COUNT(EMPID)>1
| Is This Answer Correct ? | 4 Yes | 1 No |
Post New Answer View All Answers
Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication
what is denormalization and when would you go for it? : Sql server database administration
What is normalization and its types?
What is the difference between dbcc indexdefrag and dbcc reindex?
How to resolve the orphan use problem? : sql server security
Define primary key?
How do you rename a table in sql server?
A user is a member of the public role and the sales role. The public role has select permission on all the tables. The sales role does not have select permission on some of the tables will the user be able to select from all tables?
How to update muliple row in single query?
How to start and end transact-sql statements?
How will you go about resolving deadlocks?
What does executeupdate return?
when would you go for denormalization? : Sql server database administration
What samples and sample databases are provided by microsoft?
 Explain what is sql override for a source taLle in a mapping?
