ROWID Function [Miscellaneous]

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

Syntax

ROWID ( table-name ) …FROM table-name

Parameter	Description
table-name	The name of the table. Specify the name of the table within the parentheses with either no quotes or with double quotes.

UNSIGNED BIGINT

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 with other clauses to manipulate specific rows of the table.

You must specify the FROM table-name clause.