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

4 votes133 views3 answers
Sql find second highest salary employee
SQL
19 votes140 views6 answers
Sql drop table if exists
SQL
0 vote137 views1 answer
Price-colour
SQL
0 vote139 views1 answer
Mysql max number not returning correct value
SQL
24 votes133 views4 answers
How to add column sql
SQL
-1 vote132 views2 answers
Postgres autoincrement primary key
SQL
0 vote142 views7 answers
10 random questions use python and SQL
SQL
1 vote158 views1 answer
Mysql dump specific tables
SQL
2 votes151 views1 answer
Merge firstname and lastname in sql oracle
SQL
0 vote123 views1 answer
Dnsmasq.conf location macos
SQL