Databases Reporting with SQL Date and Time Functions Formatting Dates For Reporting

Gregory Ledger
Gregory Ledger
6,116 Points

Why a comma after SELECT *

Formatting dates, there is a comma after SELECT *. If you remove the comma, you get an error, but I've never seen it used before.

1 Answer

Steven Parker
Steven Parker
203,226 Points

:point_right: Columns in a SELECT statement are separated by a comma (,).

I'd bet you have seen this before, but perhaps just not with the "all columns" symbol (*). It's still just separating it from an additional column that will be returned by the SELECT.