Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

delete first row in sql

-- MYSql:
DELETE FROM table LIMIT 1;
-- Postgres:
DELETE FROM table LIMIT 1;
-- MSSql:
DELETE TOP(1) FROM table;
-- Oracle:
DELETE FROM table WHERE ROWNUM = 1;
 
PREVIOUS NEXT
Tagged: #delete #row #sql
ADD COMMENT
Topic
Name
8+1 =