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
- 7765 Views
- I also Faced
- E-Mail Answers
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
What is difference between inner join and full join?
What is function of ROLLUP ?
What is a result set object returned by odbc_exec()?
What is openrowset sql server?
When should you use an instead of trigger?
How to set the current database in ms sql server?
What do you know about system database? : SQL Server Architecture
What are the different kinds of ssrs reports?
what is a deadlock? : Sql server database administration
what is database replicaion? : Sql server database administration
Benefits of Stored Procedures?
What is a select query statement in ms sql server?
Why we need sql server?
Explain what are magic tables in sql server?
What are the components of sql server service broker?
