Question - Write down the general syntax for a SELECT statement covering all the options.
Answer -
Here’s the basic syntax: (Also checkout SELECT in books online for advanced syntax)
SELECT select_list
[INTO new_table_]
FROM table_source
[WHERE search_condition]
[GROUP BY group_by__expression]
[HAVING search_condition]
[ORDER BY order__expression [ASC | DESC] ]