I tried this
SELECT *
FROM
( SELECT *
FROM mytable;
);
and this
SELECT *
FROM
( SELECT *
FROM mytable
);
Why these simple queries do not execute in Teradata?
@a_horse_with_no_name has pointed out clearly. It should be written like this.
SELECT *
FROM
(
SELECT *
FROM mytable
) as MY_TABLE;
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With