I just tried this out and it morks if you use an alias on your table:
select row_number() over (), A.* from client as A
California Fine Wire
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Stone, Joel
Sent: Tuesday, October 30, 2012 9:54 AM
To: 'Midrange Systems Technical Discussion'
Subject: how can I show row # as the first field
select row_number() over (),* from client
This doesn't work - any ideas?
This outbound email has been scanned for all viruses by the MessageLabs Skyscan service.
For more information please visit http://www.symanteccloud.com
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list To post a message email: MIDRANGE-L@xxxxxxxxxxxx To subscribe, unsubscribe, or change list options,
or email: MIDRANGE-L-request@xxxxxxxxxxxx Before posting, please take a moment to review the archives at http://archive.midrange.com/midrange-l