Can any one suggest me how do I separate the unique data and duplicate data ?

[expired user #5693]'s profile image [expired user #5693] posted 13 years ago in General Permalink
Hi,

I am new to data base queries.

can any one suggest me the command to separate the unique data and repeated data. I have the temp table contains all the records. Now I have to separate unique data into one table and repeated data into another table

Ex:-
-----

productid data
--------- -----
p1 d1
p2 d2
p2 d3

Here I have to store the data (p1,d1) into one table. And at the same time I have to store the data{(p2,d2),(p2,d3)} into another table.

Thanks in advance.

Regards
bvsr
BubikolRamios's profile image BubikolRamios posted 13 years ago Permalink
I recomend this forum:
http://www.codingforums.com/forumdisplay.php?f=7

Please login to leave a reply, or register at first.