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

1 vote190 views1 answer
Mysql select if empty result
SQL
0 vote218 views1 answer
Postgresql select fast check no rows
SQL
0 vote225 views1 answer
Two inner joins sql
SQL
0 vote199 views1 answer
How to fetch data from database in sql
SQL
0 vote134 views1 answer
Mysql collation for all languages
SQL
0 vote171 views2 answers
Sql use not in
SQL
8 votes179 views1 answer
Oracle all_source package body
SQL
0 vote189 views1 answer
Connect to ssms with python
SQL
0 vote180 views1 answer
EneratingSchemaError: Some errors occurred while generating GraphQL schema: Type Query must define one or more fields.
SQL
9 votes188 views2 answers
Sql limit to 5 results
SQL