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.
Answer Posted / vijendra singh shakya
For Employee table plz use the following Query...
select [empid] from employee group by [empid]
having count(empid)>1
Is This Answer Correct ? | 17 Yes | 0 No |
Post New Answer View All Answers
What is a mutating table error and how can you get around it?
Is it ok to shrink transaction log?
What is a View ? Can we insert, Update and delete a view?
How to create user defined functions with parameters?
What is ddl command?
How to select true false based on column value in sql server?
Should you normalize audio?
What are the parts of a function?
What do you understand by triggers?
What new changes are being made in SQL Server?
Can you edit the .rdl code associated with a linked report?
Do you know clustered and non-clustered index?
When you use @@error and try-catch?
Can an entity have two primary keys?
How are the unique and primary key constraints different?