SQL commands
This list includes commands currently supported by Network Reporting.
group by
Groups together rows in a table that share the same values in the specified columns.
GROUP BY expression [, ...]
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
inner join (or just JOIN)
For each row in the first table in the expression, the joined table includes a row for each row in the second table that satisfies the join condition.
table1 INNER JOIN table2 [ ON table1_column = table2_column ]
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
left (outer) join
After an inner join, a left join adds rows containing null values to the second table in the join, for each row that does not satisfy the join condition.
table1 LEFT [OUTER] JOIN table2 [ ON table1_column = table2_column ]
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
order by
Specifies the sort order of a query result.
SELECT column FROM table ORDER BY column1 [ASC | DESC] [, column2 [ASC | DESC] ...]
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
right (outer) join
After an inner join, a right join adds rows containing null values to the first table in the join, for each row that does not satisfy the join condition.
table1 RIGHT [OUTER] JOIN table2 [ ON table1_column = table2_column ]
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
select
Returns rows from tables, views, and user-defined functions.
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)
union
Compares and merges the results of two separate query expressions. The UNION ALL operator is used when duplicate rows (if any) must be retained in the result.
query1 UNION [ALL] query2
![Closed](../../../Skins/Default/Stylesheets/Images/transparent.gif)