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

0 vote232 views1 answer
Returning with sqlalchemy
SQL
6 votes233 views4 answers
Mysql get random row
SQL
3 votes193 views1 answer
What is having clause
SQL
0 vote216 views2 answers
Which MySQL statement is used to delete data from a database
SQL
1 vote203 views1 answer
Stored procedure return value
SQL
0 vote206 views1 answer
How to import sqlite driver class in java using maven
SQL
4 votes221 views1 answer
Mysql ip address data type
SQL
0 vote201 views1 answer
Array aggre distinct postgres
SQL
1 vote248 views1 answer
Postgresql where datetrunc month and year equal
SQL
2 votes238 views6 answers
In operator in sql
SQL