Sql

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

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

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

PREVIOUS	NEXT

Code Example
Sql :: update left join mysql
Sql :: sql find missing values between two tables
Sql :: mysql show column data types
Sql :: postgres drop column if exists
Sql :: ifnull postgres
Sql :: current setting postgres timezone
Sql :: check database size sql
Sql :: postgres convert exisiting column to text
Sql :: oracle alert log location
Sql :: get the rows from two tables whose relation is in 3rd table
Sql :: oracle current date
Sql :: sql current_timestamp
Sql :: oracle list tablespaces
Sql :: for loop postgresql
Sql :: table information in sql server
Sql :: how to check nls format in oracle
Sql :: delete all rows from table mysql
Sql :: how to use a trigger to validate input data
Sql :: psql: error: FATAL: role "postgres" does not exist
Sql :: sql get guid
Sql :: create another table from existing table sql oracle
Sql :: sql select contem uma palavra
Sql :: firebase bigquery cloud message
Sql :: What is localhost IP and MySql default port no.
Sql :: oracle trace session
Sql :: how to get slow query log in mysql
Sql :: import file mysql terminal
Sql :: how to know password of mysql root in linux terminal
Sql :: alter tablespace add datafile
Sql :: mysql convert column to uppercase