从表中选择“记录多次”

从表中选择“记录多次”

SELECt Location FROM Table1  CROSS JOIN    ( VALUES (1),(2),(3),(4)    ) AS four(dummy)

如果

4

不是一个常数，而是（如@xQbert指出/要求的）是表的行数，则可以使用以下命令：

SELECt a.Location FROM Table1 AS a  CROSS JOIN     Table1 AS b

---

如果没有

Table1

任何查询（但是很复杂），则可以将其用于4个副本：

SELECt Location FROM (       SELECt Location       --- complex query here       ...        --- inside parenthesis     UNIOn        SELECT Country       ...     ) AS Table1  CROSS JOIN    ( VALUES (1),(2),(3),(4)    ) AS four(dummy)

或此

n

副本：

WITH cte AS  ( SELECT Location       --- complex query here    ...        --- inside parenthesis    UNIOn     SELECT Country    ...  )SELECT a.Location FROM cte AS a  CROSS JOIN     cte AS b