I don't see any documented way of doing that in SQL Compact 3.5. I suppose
that what you do next to try to fake this probably depends on how you're
using the data that comes back from your query...
On 29 18:05, "Paul G. Tobey [eMVP]"<
>> Maybe I'm thinking about this the wrong way, but what do you mean by "row
>> number"? The table itself doesn't have row numbers, generally. Rows are
>> assumed to be unordered. Your query can enforce an order on them, but
>> order is unrelated to the order of items physically in the data storage
>> the table.
>> Paul T.
>>>> I'm using SQL Server Compact Edition 3.5 and I need to get row number
>>>> in my query. How can I do this?
>>>> Thanks for help!
I have the query with ORDER clause and I what to see the row number in
Something like this:
SELECT ROWNUM(), COL1, COL2 FROM TABLE1 ORDER BY COL1