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

1 vote290 views1 answer
Random name function in mysql for nvarchar
SQL
1 vote248 views2 answers
Mysql SELECT
SQL
20 votes298 views6 answers
Change password in mysql
SQL
0 vote278 views1 answer
SQL SELECT-Klausel
SQL
0 vote261 views2 answers
Find Overlapping sql
SQL
1 vote285 views2 answers
Group_concat limit mysql
SQL
5 votes257 views1 answer
List foreign key oracle
SQL
2 votes224 views1 answer
Sql view column data type
SQL
0 vote264 views1 answer
How to print out column name differently in mysql
SQL
6 votes260 views2 answers
Return columns from table sql
SQL