Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

delete duplicate records based on two distinct fields

Status
Not open for further replies.
naitx

naitx

Programmer
Apr 18, 2008
10
PH
I have a table called Products with fields ProductID,ProductName,ProductLevel,Description.


ProductName ProductID ProductLevel Description
ProdA A1 level1 blah...
ProdA A1 level1 blah...
ProdC A2 level2 blah..
ProdD A3 level3 blah..
ProdD A3 level3 blah...
ProdE A4 level3 blah...
ProdE A4 level2 blah...

what I want is an sql query that delete duplicate records based on distinct ProductID and ProductLevel fields,the result will be something like this..

ProductName ProductID ProductLevel Description
ProdA A1 level1 blah...
ProdC A2 level2 blah..
ProdD A3 level3 blah..
ProdE A4 level3 blah...
ProdE A4 level2 blah...

btw,no PK

Thanks in Advance
 
Sort by date Sort by votes
Status
Not open for further replies.

Similar threads

sal21
  • Question
Based the link above how to simulate click event
Replies
4
Views
305
2009luca
2009luca
sal21
  • Locked
  • Question
Duplicate yes
Replies
5
Views
414
strongm
strongm
2009luca
  • Locked
  • Question
TWO table with the same classname 1
Replies
3
Views
622
Andrzejek
Andrzejek
sal21
  • Locked
  • Question
dubt on API response
Replies
6
Views
637
strongm
strongm
sacsac
  • Locked
  • Question
Installing on Win11 1
Replies
4
Views
1K
sacsac
sacsac

Part and Inventory Search

Sponsor

Back
Top