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
- 7926 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
When you use @@error and try-catch?
what is the difference between them (ethernet networks and token ring networks)? : Sql server database administration
How do I delete a sql server database?
you have separate development and production systems you want to move a copy of a development database into production to do this, you do a backup on the development system and restore to the production system after a few minutes, you begin getting calls from several customers saying that they are denied access to the system why? : Sql server administration
how would you store your query in an SSRS report or a Database server?
What is database black box testing?
Explain the etl (extraction, transformation, and loading)?
Ms sql server index?
How do you clear a log file?
The external application that is executed in one of the tasks does not have a log file, but only a screen log. How can I save the data from the screen? : sql server management studio
Mention the uses of stored procedures.
What is de-normalization and what are some of the examples of it?
what stored procedure would you use to view lock information? : Sql server administration
What are the 10 characteristics of data quality?
Do you know how to implement service broker?
