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

10 votes164 views1 answer
Create table oracle
SQL
0 vote188 views2 answers
Athena drop partition
SQL
0 vote154 views2 answers
Influxdb delete measurement based on date
SQL
0 vote167 views1 answer
Remove from table where
SQL
0 vote215 views1 answer
After kill process Failed to start mysqld.service: Unit mysqld.service not found.
SQL
0 vote182 views1 answer
Print orcale
SQL
5 votes186 views2 answers
To date oracle
SQL
0 vote170 views1 answer
Sql query for getting data with join and count
SQL
0 vote209 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
0 vote183 views1 answer
Update view sql
SQL