ROWID function [Miscellaneous]

Returns the internal row ID value for each row of the table.

ROWID ( table-name ) …FROM table-name

The following statement returns the row ID values 1 through 10:

SELECT ROWID( “PRODUCTS” ) FROM PRODUCTS

The following statement returns the product ID and row ID value of all rows with a product ID value less than 400:

SELECT PRODUCTS.ID, ROWID ( PRODUCTS )
FROM PRODUCTS
WHERE PRODUCTS.ID < 400

The following statement deletes all rows with row ID values greater than 50:

DELETE FROM PRODUCTS
WHERE ROWID ( PRODUCTS ) > 50

You can use the ROWID function in conjunction with other clauses to manipulate specific rows of the table.

You must specify the FROM table-name clause.

A limitation of the ROWID function is that it cannot use a join index of that table, eliminating any performance benefits that would normally use that join index.