+ 1
Can you tell if a subquery be inserted by any other method except using aggregate function or relational operator
Sql subquery use
3 Respuestas
+ 4
You can use subqueries to construct new tables you select from
SELECT * FROM
(
SELECT a.X, a.Y FROM a_table AS a
WHERE a.Z > 3
) as _;
(no aggregation, no relational operator)
0
common table expression (CTE):
WITH TEMP
AS
(
SELECT X.FIELD_A
,X.FIELD_B
FROM TABLE X
)
SELECT TEMP.FIELD_A
, TEMP.FIELD_B
FROM TEMP
;
0
yes