different form of SELECT

hi,

I am doing a documentation on select statement, so please provide me links or the various forms of select query like

SELECT ENDSELECT.

SELECT SINGLE

SELECT DISTINCT

SELECT AVG()

etc...

Points assured

regards,

Prabhu