How to use select union and loop

CREATE TABLE #Temp
(
  <COLUMNS>
)

 DECLARE @position INT
 SET @position = -1

 WHILE(@position < 1)
 BEGIN

    INSERT INTO #Temp (<COLUMNS>)
    SELECT * FROM mytable

    SET @position = @position + 1

 END

 SELECT * FROM #Temp

Source: stackoverflow.com

Similar codes

0 vote144 views1 answer
Desinstaller mysql sur ubuntu definitivement
SQL
0 vote131 views3 answers
Select random sql
SQL
0 vote131 views1 answer
Sql query interview questions githu
SQL
9 votes156 views1 answer
Alter table column change data type to text mysql
SQL
0 vote149 views3 answers
Mysql keyword search
SQL
0 vote134 views1 answer
Python list from sql
SQL
0 vote182 views1 answer
Database disk image is malformed sqlite fix ubuntu
SQL
0 vote122 views1 answer
Mysql concat and use as where column
SQL
1 vote150 views1 answer
Create index concurrently postgres
SQL
5 votes138 views2 answers
Ranking functions in sql
SQL