| 2. Query Select |
| 2. 1. Introduction( 3 ) | 2. 22. IS NOT INFINITE( 1 ) |
| 2. 2. Select clause( 16 ) | 2. 23. IS NOT NAN( 1 ) |
| 2. 3. Where( 10 ) | 2. 24. IS NULL( 5 ) |
| 2. 4. Order By( 17 ) | 2. 25. NOT( 11 ) |
| 2. 5. Group By( 20 ) | 2. 26. NOT BETWEEN( 1 ) |
| 2. 6. HAVING( 8 ) | 2. 27. NOT IN( 6 ) |
| 2. 7. DISTINCT( 3 ) | 2. 28. NOT LIKE( 1 ) |
| 2. 8. Columns( 12 ) | 2. 29. Level( 2 ) |
| 2. 9. Concatenation( 1 ) | 2. 30. ROWID( 2 ) |
| 2. 10. Arithmetic( 3 ) | 2. 31. rownum( 4 ) |
| 2. 11. AND OR( 13 ) | 2. 32. GUID( 1 ) |
| 2. 12. Alias( 10 ) | 2. 33. ROW( 3 ) |
| 2. 13. ALL( 3 ) | 2. 34. START WITH( 2 ) |
| 2. 14. ANY( 3 ) | 2. 35. with( 2 ) |
| 2. 15. CASE( 15 ) | 2. 36. Single Row Subquery( 20 ) |
| 2. 16. BETWEEN( 4 ) | 2. 37. Correlated Subquery( 11 ) |
| 2. 17. IN( 12 ) | 2. 38. Multiple Row Subquery( 11 ) |
| 2. 18. EXISTS( 6 ) | 2. 39. Nested Subquery( 4 ) |
| 2. 19. LIKE( 12 ) | 2. 40. Hierarchical Queries( 12 ) |
| 2. 20. IS INFINITE( 1 ) | 2. 41. Multi column subquery( 3 ) |
| 2. 21. IS NAN( 1 ) | 2. 42. CONNECT( 3 ) |