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.5
Overall Rating
72%
17%
6%
0%
5%
Reviews
P
Priya Kushwaha
5
Very Good trainer
C
chanchal singh
5
you guys are doing nice job. thanks
U
Umesh Wankhede
5
Not too much interactive
M
Monesh Ram
5
Well Explained in Every Chapters..
G
GAJANAN DIGAMBAR MODE
5
very easy to understand SQL its was dream to learn SQL. Thanx for Learnvern
M
Mohmad Shadab
5
BEST VIDEOS
N
NAGASWETHA
5
very useful
M
mohd aamir
4
Hi Team,
Why you didn't teach/learn how to write select query, even you shared 15 question for practice :(
Y
Yashvant Kadwe
5
I have found the course to be interesting with plenty of valuable information provided as part of the course and through interaction with fellow teachers and trainers from a wide range of disciplines
Share a personalized message with your friends.