Showing entries 1 to 1
Displaying posts with tag: Derived column lists (reset)
Jun
24
2014
Should I Put That Table Alias or Not?
Posted by Lukas Eder on Tue 24 Jun 2014 09:08 UTC
Tags:

Infrequent SQL developers often get confused about when to put parentheses and/or aliases on derived tables. There has been this recent Reddit discussion about the subject, where user Elmhurstlol was wondering why they needed to provide an alias to the derived table (the subselect with the UNION) in the following query: SELECT AVG(price) AS AVG_PRICE … Continue reading Should I Put That Table Alias or Not? →

Showing entries 1 to 1