Northwind Database Queries

Q. Is the WHERE clause must appear always before the GROUP BY clause in SQL SELECT ? A. Yes. The proper order for SQL SELECT . clauses is: SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY. Only the SELECT and FROM clause are mandatory. Q. How Oracle executes a statement with nested subqueries? A. When Oracle executes a statement with nested ... ................
................