News for hackers. Stuff that matters.

A comment on Pipe Syntax in SQL. Parent comment

Re:Pipe Syntax in SQL by akira2501 on Saturday August 24, 2024 @02:39PM (#41340383) 

    SELECT 1+2;
FROM clauses aren't required, and using multiple tables in FROM doesn't seem to work out too well when that syntax is listed first.
[ Parent | on HN ]
Re:Pipe Syntax in SQL by yen223 on Saturday August 24, 2024 @03:56PM (#41341005)
WITH clauses are optional and appear before SELECT. No reason why the FROM clause couldn't behave the same
[ Parent | on HN ]
Re:Pipe Syntax in SQL by akira2501 on Saturday August 24, 2024 @04:45PM (#41341348)
Isn't that strictly for CTEs? In which case, you are SELECTing from the CTE.
[ Parent | on HN ]
Re:Pipe Syntax in SQL by ElectricalUnion on Sunday August 25, 2024 @12:48AM (#41344465)
Beginning with Oracle Database Release 23 [released May 2, 2024], it is now optional to select expressions using the FROM DUAL clause.
[ Parent | on HN ]
Re:Pipe Syntax in SQL by thiht on Sunday August 25, 2024 @04:54AM (#41345694)
Doesn’t change anything, you can still have the select at the end, and optional from and joins at the beginning. In your example, the select could be at the end, it’s just that there’s nothing before.
[ Parent | on HN ]