Re: query to update record by the position of row

2002-07-09 Thread Dan Nelson
In the last episode (Jul 09), Pichan M. said: > Is there a query to update record by specify the position of record > or row? > > update tableA set col_name = "somthing" ...( at row number 123) SQL tables do not have row numbers. The only way to absolutely identify a record is by a unique ID in

query to update record by the position of row

2002-07-09 Thread Pichan M.
Is there a query to update record by specify the position of record or row? update tableA set col_name = "somthing" ...( at row number 123) thanks for help! Regards, _ MSN Photos is the easiest way to share and print your photos: