- Notifications
You must be signed in to change notification settings - Fork689
Select Columns
Mathias Rangel Wulff edited this pageJun 12, 2015 ·4 revisions
Columns
SELECT sizeSELECTCity.Name,City.Population
Expressions
SELECT LCASE(City),2+2
Aggregators
SELECTCOUNT(*),SUM(Population)
Alias
SELECT City+” “+CountryAS LongName
Select all columns from table
SELECT*, City.*
Select columns of arrays
SELECT [0],[1]
Column names with spaces, etc
SELECT [My Column]-- SQL Server styleSELECT`My Column`-- MySQL style
© 2014-2026,Andrey Gershun &Mathias Rangel Wulff
Please help improve the documentation by opening a PR on thewiki repo