SQL components to specify sorting, displaying, grouping

SQL Statement Syntax Example Statement Example Result or Description 
AS (alias)
 
SELECT column_name AS column_alias
FROM table_name
or
SELECT column_name
FROM table_name  AS table_alias
 
select Carrier, count(*) as Count from device 
group by Carrier
 

Use AS if you want to provide a different label for a column in the report results.

 
GROUP BY
 
SELECT Carrier, count(*) AS Count from device 
GROUP BY Carrier
 
select Carrier, count(*) as Count from device 
group by Carrier

Use GROUP BY to organize the report results by a specified column value.

 
ORDER BY
 
SELECT column_name(s)
FROM table_name
ORDER BY column_name [ASC|DESC]
 
select Name, Count(*) as Count from InstalledApp
group by name 
order by count desc

Use SORT BY to sort the report results by a specified column value.