Search
 
SCRIPT & CODE EXAMPLE
 

SQL

sql delete last row

DELETE FROM my_table WHERE my_col_id = (SELECT MAX(my_col_id) FROM my_table);
Comment

how to delete last row in sql

DELETE FROM MARKS WHERE ID=(SELECT MAX(id) FROM MARKS)
Comment

how to delete last row in sql

DELETE FROM my_table WHERE my_col_id = (SELECT MAX(my_col_id) FROM my_table);
Comment

PREVIOUS NEXT
Code Example
Sql :: SQL INNER JOIN With Three Tables 
Sql :: how to find sql server installation folder 
Sql :: how to get information about data types in postgreSQL 
Sql :: changing name of column and datatype in sql 
Sql :: spark apache sql coalesce 
Sql :: hibernate show sql xml property 
Sql :: find the all the constraints in a specific table 
Sql :: mysqldump devilbox 
Sql :: Rows, INSERT INTO, Returning 
Sql :: check if table is Temporal 
Sql :: select year from dual oracle 
Sql :: oracle uptime 
Sql :: postgres insert into table 
Sql :: how to set all the time serveroutput on in oracle sql developer 
Sql :: show sql property syntax for jpa. 
Sql :: oracle disk group space 
Sql :: mysql pass command from command line 
Sql :: oracle datafile max size 32gb 
Sql :: create table if not exists 
Sql :: postgresql inheritance 
Sql :: h2 auto increment and unique 
Sql :: wp sql to update admin email 
Sql :: cross join sl 
Sql :: WHERE value IS sql 
Sql :: insert data to postgresql from excel 
Sql :: google sheets filter rows above current cell 
Sql :: mysql update LAST_INSERT_ID() 
Sql :: select columns from 2 tables with foreign key 
Sql :: case statement in sql 
Sql :: insert value to new table by joining 2 different tables 
ADD CONTENT
Topic
Content
Source link
Name
7+8 =