Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
How to split the data of source table column-wise with respect to primary key
How to split the data of source table column-wise with respect to primary key. See the source and target tables below.
source table: ID is the key column, Name and Phone No are non-key columns
ID Name Phone No
10 AAA 123
20 BBB 234
30 CCC 434
40 DDD 343
50 EEE 442
Target Table 1
ID Name
10 AAA
20 BBB
30 CCC
40 DDD
50 EEE
This is the exact question?