Select first occurrence of Duplicate!!!

ssowmya · New User Joined: 10 Oct 2006 Posts: 40

Hi All

I have a table with following info

Vendor-ID Vendor-Name Loc-Name Loc-Seq
00001 Vendor1 A 1
00001 Vendor1 B 1
00002 Vendor2 A 2
00002 Vendor2 A 2
00002 Vendor2 B 1
00003 Vendor3 A 3

I want to extract the records in following format

Vendor-ID Vendor-Name Loc-Name Loc-Seq
00001 Vendor1 A 1
00002 Vendor2 A 2
00003 Vendor3 A 3

That is the first occurrence of Vendor_ID

Please help.....

vicky10001 · Active User Joined: 13 Jul 2005 Posts: 136

Please find the below link

www.databasejournal.com/features/postgresql/article.php/3437821

I think its helpfull you

raghunathns · Posted: Wed Jan 03, 2007 12:08 am

You mean the column loc-seq is duplicate and find the location which is occuring first.

try this.

select * from tbl1 x
where 0 = (select count(*) from tbl1 y
where y.vendor-name = x.vendor-name
and y.Loc-Seq = x.Loc-Seq
and y.loc-name < x.loc-name)
order by x.vendor-id

.