Harald Fuchs wrote:
> In article <[email protected]>,
> Christopher Kings-Lynne <[email protected]> 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"
