distal-attribute
distal-attribute
distal-attribute
distal-attribute

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

User, date Message
Written by venkatasateesh
3 years ago
Category: General
1 posts since Thu, 05 May 11
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
Written by BubikolRamios
3 years ago
327 posts since Thu, 14 Jan 10
I recomend this forum:
http://www.codingforums.com/forumdisplay.php?f=7
 

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