+ 1

Can you tell if a subquery be inserted by any other method except using aggregate function or relational operator

Sql subquery use

23rd Jul 2018, 7:43 PM
Shruti Shivhare
Shruti Shivhare - avatar
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)
23rd Jul 2018, 8:25 PM
Kuba Siekierzyński
Kuba Siekierzyński - avatar
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 ;
23rd Jul 2018, 9:11 PM
Mindshadow
Mindshadow - avatar
0
yes
24th Jul 2018, 2:44 AM
gregori schneider
gregori schneider - avatar