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
Can any one suggest me how do I separate the unique data and duplicate data ?
I recomend this forum:
http://www.codingforums.com/forumdisplay.php?f=7
http://www.codingforums.com/forumdisplay.php?f=7
Please login to leave a reply, or register at first.