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
- 7188 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 stored procedure would you use to view lock information?
Explain the disadvantages of cursors?
What is a document index?
What is the process of normalising?
You are designing a strategy for synchronizing an SQL Azure database and multiple remote Microsoft SQL Server 2008 databases. The SQL Azure database contains many tables that have circular foreign key relationships?
How to see existing views in ms sql server?
What is the syntax for encrypting a column in SQL Server?
What is database isolation in sql server? : sql server database administration
What is named query? : sql server analysis services, ssas
what type of index will get created after executing the above statement? : Sql server database administration
What happens if the update subquery returns multiple rows in ms sql server?
What is self contained multi valued query?
How raid can influence database performance?
How do I get to sql server configuration manager?
What is Command line parameters in PLSQL.?
