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

11 votes143 views1 answer
Sql query to find duplicates in column
SQL
0 vote145 views1 answer
Sqlite commands
SQL
0 vote160 views3 answers
Convert sql query to python pandas
SQL
23 votes151 views2 answers
Query to delete a database in mysql
SQL
1 vote137 views1 answer
Where date = max(date) in sql
SQL
1 vote134 views1 answer
Sql server find tables referenced foreign key
SQL
8 votes137 views1 answer
Sql limit results returned
SQL
0 vote131 views1 answer
Check mysql password with docker container magento 2
SQL
1 vote141 views1 answer
Mysql remove last empty newline
SQL
0 vote136 views1 answer
Get the Domain Name, Page Name and Query Parameter from a URL
SQL