SQL – Query Table for List of Columns

Select * From tablename

-- Select certain columns ("longitude","latitude","housing_median_age")
Select longitude,latitude,housing_median_age
From tablename

-- Select certain columns ("longitude","latitude","housing_median_age"),
-- top n rows (5),
Select longitude,latitude,housing_median_age
From tablename Limit 5

-- Select certain columns ("longitude","latitude","housing_median_age"),
-- top n rows (5),
-- order by certain columns ("housing_median_age","latitude") asc | desc,
Select longitude,latitude,housing_median_age
From tablename
Order By housing_median_age Asc ,latitude Desc
Limit 5