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 are the tables in sql?
Why olap is used?
What is ms sql server service broker?
Define self join?
What is sql server replication? : sql server replication
How to backup encryption key ?
How do I setup a sql server database?
List layers of abstraction microsoft architectured to provide relational db through cloud platform ?
Why do we use trigger?
‘Order by’ is not allowed in a view how can you sort information from a view?
How do I find sql server instance name?
What is a recursive stored procedure in sql server?
How to end a stored procedure properly in ms sql server?
What happens if ntwdblib.dll is missing on your machine?
How do users use Report Builder with SQL Server data sources?