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 vote150 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote151 views1 answer
How do you use sql in you company
SQL
1 vote258 views3 answers
Create table from existing table in sql
SQL
1 vote155 views1 answer
Oracle apex version view
SQL
1 vote141 views1 answer
Import sql file mysql commadn line
SQL
0 vote150 views1 answer
BigQuery Remove Duplicate Keys From Table
SQL
1 vote153 views1 answer
Postgresql pass array in function
SQL
5 votes137 views1 answer
Sort order on two columns sql
SQL
0 vote124 views1 answer
Make a socket server to detect changes in mysql
SQL
0 vote93 views1 answer
Online sql compiler
SQL