May 24, 2019 at 1:11 pm
table1
id value
2 20
3 30
4 40
5 50
6 60
7 null
the above table has to be inserted into another table2 with following fashion
i,e: it has to insert the value corresponding to 2 into col1 when id =2 ,col2 when id=3 and so on. note: insert empty when null is the value
table2
col1 col2 col3 col4 col5 col6
20 30 40 50 60 empty
May 24, 2019 at 7:59 pm
What would you insert if there are multiple source rows with the same Id? For example
id value
2 20
2 30
Would this require two inserts of 20 and 30, or a single insert of 50 (SUM), 25 (AVG), 20 (MIN) ... or some other aggregate?
May 25, 2019 at 12:29 am
There multipl wont be any scenario like multiple source rows with the same Id in my case
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy