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

2 votes219 views3 answers
How do I add a user to a postgres database? cli
SQL
8 votes182 views2 answers
Alert table name mysql
SQL
7 votes203 views6 answers
Mysql group concat
SQL
2 votes215 views1 answer
Oracle kill session by sql_id
SQL
15 votes184 views2 answers
Select where duplicate mysql
SQL
0 vote236 views1 answer
What does the -p flag do in mysql cli
SQL
0 vote290 views1 answer
How to show current database in mysql
SQL
2 votes179 views2 answers
TSQL GET ALL COLUMNS IN TABLE
SQL
6 votes191 views2 answers
Sql query to get the number of rows in a table
SQL
1 vote218 views1 answer
Postgresql blocked on mac
SQL