Hi All,
Here is the scenario, I have a table called "Table1" which updates on real time basis, i want to copy the data from Table1 to my newly created Table2 which is having 2 columns, Number and Count.
While copying the data from Table1 to Table2 if it founds matches record in "Number" column then it increments it to 2 in Count column.
Need query for above mentioned scenario.....any help will be remembers in good wordings.....
Bookmarks