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 / 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
If the job running very slow what is the action you do
Does sql server use java?
What is stored in the mssqlsystemresource database? : sql server database administration
What are the hotfixes and patches in sql server?
Explain what is raid and what are different types of raid levels?
Describe different Processing Modes offered by SSRS?
What is msdb database? : SQL Server Architecture
How to list all stored procedures in the current database using ms sql server?
How do I clean up sql server transaction log?
What is meant by indexing files?
What is sql azure database?
How self join is different from outer join?
Are null values the same as that of zero or a blank space?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is view in sql?