[schema .] table ( [schema .] [table] column [ ASC | DESC ] [, [schema .] [table] column [ ASC | DESC ]]... ) FROM [schema .] table [, [schema .] table]... WHERE condition [local_partitioned_index] index_attributes