Query Select « Oracle PL/SQL Tutorial

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 )