My contemplations and diurnal novelties are publicized here


Consider table “tbl_dispatchreport” is having duplicate record in the column drcode

We can use group by with having to find the duplicate rows

select count(drcode),drcode from tbl_dispatchreport

group by drcode

having count(drcode) > 1

Advertisements

Comments on: "How to find duplicate records in a table" (2)

  1. Aftab Alamgir said:

    I need dulicate bills from April 2006 to August 2008

  2. Aftab Alamgir said:

    I need duplicate bills from April 2006 to August 2008

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: