Code: Select all
delete from
(select * from <TABLE> fetch first 2 rows only)
Error: SQL0104N An unexpected token "(" was found following "(" ...
Code: Select all
delete from
(select * from <TABLE> fetch first 2 rows only)
Error: SQL0104N An unexpected token "(" was found following "(" ...
Code: Select all
DELETE FROM table_name
WHERE some_column=some_value;
Code: Select all
delete from <TABLE_NAME>
where (<KEY>) in (
select <KEY> from <TABLE_NAME>
where <CONDITION>
FETCH first <N> rows only )
Code: Select all
DELETE FROM <TABLE_NAME>
WHERE rid(<TABLE_NAME>) <= (SELECT max(rid) FROM (
SELECT rid(<TABLE_NAME>) AS rid
FROM <TABLE_NAME>
ORDER BY rid(<TABLE_NAME>)
FETCH FIRST <N> ROWS ONLY) i)
Return to “Other Programming Languages”
Users browsing this forum: No registered users and 30 guests