| 1.Query | ||
| 1.1.Query Select( 18 ) | 1.17.ANY( 6 ) | |
| 1.2.where( 10 ) | 1.18.Some( 2 ) | |
| 1.3.Order by( 16 ) | 1.19.AND( 2 ) | |
| 1.4.GROUP BY( 8 ) | 1.20.OR( 4 ) | |
| 1.5.Having( 7 ) | 1.21.Not( 6 ) | |
| 1.6.Null( 2 ) | 1.22.AS( 2 ) | |
| 1.7.IS NOT NULL( 1 ) | 1.23.Case( 19 ) | |
| 1.8.IS NULL( 3 ) | 1.24.arithmetic operator( 1 ) | |
| 1.9.Between( 8 ) | 1.25.Math Calculation( 4 ) | |
| 1.10.Exists( 6 ) | 1.26.Logical operator( 11 ) | |
| 1.11.In( 7 ) | 1.27.Comparison operators( 7 ) | |
| 1.12.DISTINCT( 7 ) | 1.28.Query Hints( 2 ) | |
| 1.13.LIKE( 16 ) | 1.29.Select Into( 6 ) | |
| 1.14.Column Alias( 5 ) | 1.30.TABLESAMPLE( 1 ) | |
| 1.15.Top( 10 ) | 1.31.ROWGUIDCOL( 1 ) | |
| 1.16.ALL( 8 ) | 1.32.rowversion( 1 ) | |