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( “PRODUCT” ) FROM PRODUCT

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

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

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

DELETE FROM PRODUCT
WHERE ROWID ( PRODUCT ) > 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.