Use of XML For and STUFF Function | SQL Query | SQL Interview Question | Sukhraj

Multiple duplicate rows with only one column that is different.
How we can combine those columns into the same row.
Use of XML For and STUFF Function
The STUFF() function deletes a part of a string and then inserts another part into the string, starting at a specified position.
STUFF(string, start, length, new_string)
#SQL #SQLServer

[@user-qz5lk2dd5g]

Its not complicated at all, you explianed it very easily. Thanks a ton for the video.

[@AmirKhan-sh7tb]

Nycly explain

[@SukhrajMohammad]

The STUFF() function deletes a part of a string and then inserts another part into the string, starting at a specified position.
STUFF(string, start, length, new_string)

[@superfreiheit1]

3:44 Why you dont use distinct City in the select clause?

[@SukhrajMohammad]

distinct will not work here because city column has different value for each record related to same user, so when city gets change ,record no more remains unique...