Guys,
I may be showing my ignorance
but I can’t seem to include RowID in an SQL query.
EG:
Select Col1, Col2,
Col3, ROWID “RowIdentifier” from…
I dug up an old post:
|
[MI-L] Returning RowID in the Select Statement (SQ
|
|
Author: Ben
A Greenberg (207.250.113.---)
Date: 03-25-2006 08:17
I am querying a large dataset and would like the select query to return the
RowID as a temporary column.
Can this be done.
When i run the following query:
|
|
But couldn’t find
and answer.
Can anybody help?
Cheers
Percy
Percy Bell
Research Statistics and
Technology Branch
Phone: (02) 6271 1463
Mob: (0415) 260 805
Fax: (02) 6271 1144
Department of Communications,
Information Technology and the Arts
GPO Box 2154, Canberra ACT 2601 Australia
URL:http://www.dcita.gov.au
Email: [EMAIL PROTECTED]
_______________________________________________________________________________________________________
The information transmitted is for the use of the intended recipient only and may contain confidential and/or legally privileged material.
Any review, re-transmission, disclosure, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited and may result in severe penalties.
If you have received this e-mail in error please notify the Security Advisor of the Department of Communications, Information Technology and the Arts, telephone (02) 6271-1880 and delete all copies of this transmission together with any attachments.
For all other enquiries please ring (02) 6271-1000.
_______________________________________________________________________________________________________
|
|
_______________________________________________
MapInfo-L mailing list
[email protected]
http://www.directionsmag.com/mailman/listinfo/mapinfo-l
