When you unpivot, you unpack the attribute-value pairs that constitute the new columns' intersection points and re-orient them into flattened columns as follows: Values are unpivoted into a new column (in blue on the left) (in blue on the right).
Replace values does not pick up new columns when they are introduced to the table, therefore the unpivot removes the rows with null values from the new column.
Learner's Ratings
4.3
Overall Rating
71%
11%
7%
0%
11%
Reviews
V
Vishnu Suvaliya
5
Forums.learnvern.com cant work
A
Ankush Raj
5
good
R
ruhina qureshi
5
Awesome Classes ,Both tutors explains the concept very nice
Y
Yadav Aakash
5
very useful thank you learnvern
A
Ashish
5
The course is very good. I have stuck at a point that how you create multiple rows with a single insert in sales.customer table. I get only one customer data. this table is related to bikestore data.
Share a personalized message with your friends.