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

3 votes344 views2 answers
Mysql select database
SQL
0 vote344 views7 answers
Les jointures sql server
SQL
0 vote339 views1 answer
Laravel general error 2006 mysql server has gone away
SQL
1 vote366 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote410 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote306 views2 answers
How to combine two sql queries in one result
SQL
0 vote356 views2 answers
Postgresql variable in query
SQL
0 vote341 views1 answer
Check duplicate values plsql
SQL
0 vote343 views1 answer
Start and stop mysql
SQL
0 vote376 views1 answer
Can you write relational algebra into sql queries
SQL