1.

Query to repeat rows N times as per the column Value in SQL Server?

Answer»

Query to repeat ROWS N TIMES as PER the COLUMN Value in SQL Server?
To Repeat Rows n times ACCORDING to column value we will write some query. To understand this first we will create a table as per below given.


Repeat Row
Output of above query is given below:-


Repeat Table
Now we will write below query to get the row repeated.


Repeat Query
Now the final output as per the row repeated.


RepeatRowOutput


Discussion

No Comment Found

Related InterviewSolutions