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

5 votes149 views1 answer
Sqlite alter table add column
SQL
12 votes205 views6 answers
How to install sqlite3 in python
SQL
0 vote151 views1 answer
Mysql search multiple tables
SQL
11 votes170 views2 answers
Oracle saurce code
SQL
40 votes237 views4 answers
PostgreSQL add column
SQL
0 vote140 views1 answer
Count the table indatabase
SQL
0 vote124 views1 answer
Prevent duplicate rows in postgres
SQL
0 vote309 views2 answers
Create new table from existing table with data in sql server
SQL
1 vote173 views1 answer
Postgres left join
SQL
16 votes198 views3 answers
Order by sql query
SQL