Harald Fuchs wrote:
> In article <4312783F.4050603@familyhealth.com.au>,
> Christopher Kings-Lynne <chriskl@familyhealth.com.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"