Can any one suggest me how do I separate the unique data and duplicate data ?
| User, date | Message |
|---|---|
|
Written by venkatasateesh
2 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
2 years ago 275 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. |