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
- 7661 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
Explain how many types of relationship?
Where do you find the default Index fill factor and how to change it?
What types of replication are supported in sql server?
How to define output parameters in stored procedures?
Explain what are the database objects? : SQL Server Architecture
What are the different types of cursor?
Why normalization is used?
What are ddl triggers and types of ddl trigger?
How to get a list of columns using the "sp_help" stored procedure in ms sql server?
How many types of triggers are there?
Does index speed up select statements?
Explain indexed views and partitioned view with their syntax.
how many triggers you can have on a table? : Sql server database administration
Why is normalisation important?
Can we shrink data file in sql server?
