Home
SQL programmingYou can use the HCL OneDB™ implementation of the SQL language to develop applications for HCL OneDB™ database servers.
Guide to SQL: SyntaxThe HCL OneDB™ Guide to SQL: Syntax describes the syntax of the statements, data types, expressions, operators, and built-in functions of the HCL OneDB™ dialect of the SQL language.
SQL statementsThis chapter describes the syntax and semantics of SQL statements that are recognized by HCL OneDB™.
DELETE statementUse the DELETE statement to delete one or more rows from a table, or to delete one or more elements from a collection variable of SPL or of .
Using the WHERE Keyword to Specify a Condition

Using the WHERE Keyword to Specify a Condition

Use the WHERE condition clause to specify which rows you want to delete from the table. The condition after the WHERE keyword is equivalent to the condition in the SELECT or UPDATE statement. For example, the next statement deletes all the rows of the items table where the order number is less than 1034:

DELETE FROM items WHERE order_num < 1034;

In DB-Access, if you include a WHERE clause that selects all rows in the table, DB-Access gives no prompt and deletes all rows.

If you are deleting from a supertable in a table hierarchy, a subquery in the WHERE clause cannot reference a subtable.

When deleting from a subtable, a subquery in the WHERE clause can reference the supertable only in SELECT ... FROM ONLY (supertable)... syntax.