Harald Fuchs wrote:
> In article <4312783F(dot)4050603(at)familyhealth(dot)com(dot)au>,
> Christopher Kings-Lynne <chriskl(at)familyhealth(dot)com(dot)au> writes:
>>
>>Oh, and 'select rowid, * from table' which returns special rowid
>>column that just incrementally numbers each row.
>
> Why?
Perhaps Christopher meant
"select row_number() OVER (...) as rowid"
and then your "why" could be answered by
"SQL Standard non-core feature T611"