Sql Server Blog
Blog Archive
►
2012
(4)
►
November
(1)
►
June
(1)
►
April
(1)
►
February
(1)
►
2010
(8)
►
January
(8)
▼
2009
(9)
►
November
(1)
▼
October
(8)
Search string in any column in a table
Counting rows in a table for improving performance...
Searching in a column of any table by a substring
Select desired rows from table by IN Keyword
Select top two rows from SQL server database table
Insert rows/records from one table to another table
How to select Duplicate Rows from a table
Create Serial Number Column using SQL Server
Connect
C# DOT NET for Developers
Remove all XML tags from a string
11 years ago
ASP Developer
Read client side IP Address
15 years ago
Followers
ClustrMaps of Visitors
About Me
Amit Pal
Associate Project Manager, HCL Technologies Ltd. Noida
View my complete profile
Wednesday, October 7, 2009
How to select Duplicate Rows from a table
Below is the query to select duplicate rows from a table.
select email,count(*) from database_Amit group by email having count(*)>1
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment