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
- 7762 Views
- I also Faced
- E-Mail Answers
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 the difference between DataRow.Delete() and DataRow.Remove()?
Explain what are the different index configurations a table can have?
Define self join in sql server joins?
What is conditional split?
Why do we use trigger?
Is it safe to delete log files?
Mention the differences between having and where clause.
Which Model uses the SET concept
What does the on update no action do?
What are sql azure firewall rules?
How to check if stored procedure is running in sql server?
Explain how to send email from sql database?
How to set a database state to offline in ms sql server?
Is there any difference between primary key and unique with the not null condition?
what are user defined datatypes and when you should go for them? : Sql server database administration
