order of operation for sql code example
Example 1: order by sql
//this_for_descending_order..
SELECT * FROM TableName ORDER BY columnName DESC;
// this_for_ascending_order..
SELECT * FROM TableName ORDER BY columnName ASC;
Example 2: sql order of operations
SELECT DISTINCT column, AGG_FUNC(column_or_expression), …
FROM mytable
JOIN another_table
ON mytable.column = another_table.column
WHERE constraint_expression
GROUP BY column
HAVING constraint_expression
ORDER BY column ASC/DESC
LIMIT count OFFSET COUNT;