Standard SQL parsing Sequence

You can see an SQL query statement in csdn as follows:

Select * , Row_number () Over ( Order By Productname) As Rownumber
From Products Where Rownumber Between 10 And 20

 

The problem is that this SQL statement reports an error.After analysis, we found that this is related to the SQL parsing sequence..This is because row_number is not calculated during where calculation. Therefore, SQL statements report errors.

The standard SQL parsing sequence is as follows:

( 1 ). From Clause to assemble data from different data sources
( 2 ). Where Clause to filter records based on specified conditions.
( 3 ). Group By Clause to divide data into multiple groups.
( 4 ). Use Aggregate functions for Calculation
( 5 ). Use Having Clause filter group
( 6 ). Calculate all expressions
( 7 ). Use Order By Sort result sets