Write down the query to display all student name in one cell seprated by ‘,’ example:-“Sara, David, Dora, Jack, Vikram, Ross”.

YasminRadwan26

Save to bookmark

2022-05-13

1537

Database, Sql programming, Interview questions, Database Interview-questions, Sql programming Interview-questions,

YasminRadwan26

2022-05-13

need an explanation for this answer? contact us directly to get an explanation for this answer

Declare @name varchar(MAX) = ''
Select @name = @name + FirstName + ', ' from [tblStudent]
Select SUBSTRING(@name,1, LEN(@name)) As StudentList

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)