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

7 votes351 views5 answers
Show details of table postgres
SQL
1 vote296 views1 answer
Postgres division by zero
SQL
53 votes539 views6 answers
Sql server alter column
SQL
1 vote377 views2 answers
Truncate table sqlite
SQL
0 vote355 views1 answer
Mysql date without time
SQL
0 vote338 views1 answer
Mysql date minus 1 day
SQL
1 vote363 views1 answer
Oracle insert multiple rows into same table
SQL
0 vote316 views1 answer
Resulting Query
SQL
1 vote372 views1 answer
Sql row having max
SQL
0 vote361 views2 answers
Create row number in sql
SQL