Search
 
SCRIPT & CODE EXAMPLE
 

SQL

postgresql delete limit

DELETE FROM logtable
WHERE ctid IN (
    SELECT ctid
    FROM logtable
    ORDER BY timestamp
    LIMIT 10
)
Comment

PREVIOUS NEXT
Code Example
Sql :: Create table Statement Syntax in SQL Server 
Sql :: sql email Regex 
Sql :: oracle drop job if exists 
Sql :: how to lock table in mysql 
Sql :: mysql user 
Sql :: sql if empty then 
Sql :: postgresql subtract date/hours 
Sql :: sql get inserted primary key 
Sql :: dual in db2 
Sql :: sql show table info 
Sql :: mysql get nth highest 
Sql :: sql function to add all values round of 2 decimal places 
Sql :: ERROR 3948 (42000): Loading local data is disabled; this must be enabled on both the client and server sides 
Sql :: sql round 2 decimal 
Sql :: sql order by alphabetical 
Sql :: SQL Less Than or Equal to Operator 
Sql :: mysql identified by syntax error 
Sql :: dump heroku database to sql 
Sql :: mysql repeated values 
Sql :: q operator in sql 
Sql :: sql not in 
Sql :: sample clause in sql 
Sql :: postgresql check total storage 
Sql :: postgre insert select 
Sql :: default password for mysql_secure_installation in mac 
Sql :: sql not equal 
Sql :: image for MSSQL Windows Docker 
Sql :: sql delete where in 
Sql :: postgres how to add field created at 
Sql :: checking data type in sql server 
ADD CONTENT
Topic
Content
Source link
Name
8+7 =