Search
 
SCRIPT & CODE EXAMPLE
 

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;
Comment

PREVIOUS NEXT
Code Example
Sql :: mysql where one year ago 
Sql :: primary key reset in SQL database 
Sql :: crontab every month 
Sql :: tsql get beginning of year 
Sql :: oracle start job 
Sql :: how to check last gather stats on table in oracle 
Sql :: sql between date range 
Sql :: get hour from date sql 
Sql :: postgresql print variable 
Sql :: insert column with default value in sql 
Sql :: postgresql reset auto increment 
Sql :: search for tables with name postgresql 
Sql :: convert epoch to date in sql server 
Sql :: key validation sql 
Sql :: postgresql alter column nullable 
Sql :: create table if not exists sql 
Sql :: String concatenation in PostgreSQL 
Sql :: oracle delete last row 
Sql :: sql server 2012 query history 
Sql :: check mysql timezone 
Sql :: ordering by issue with 4 digit numbers in sql 
Sql :: sql current timestamp 
Sql :: oracle export trigger ddl 
Sql :: insert postgres 
Sql :: mysql add comment to column 
Sql :: sql server roles and users 
Sql :: create column mysql terminal 
Sql :: alter table drop column 
Sql :: alter table change default 
Sql :: postgresql group by month and year 
ADD CONTENT
Topic
Content
Source link
Name
7+6 =