Sql select last id

SELECT
  (SELECT * FROM tableName ORDER BY col1 LIMIT 1)        AS first,
  (SELECT * FROM tableName ORDER BY col1 DESC LIMIT 1)   AS last
;

Source: stackoverflow.com

Sql select last id

#Where the the column name is "ID" and table name is "tablename" and ID naming is increasing numerical value.
SELECT * 
FROM tablename
WHERE ID = (
    SELECT MAX(ID) 
  	FROM Table)

Sql get last ID

SELECT MAX(id) FROM <tablename>

Similar codes

1 vote176 views1 answer
Ms sql - add one hour to time
SQL
2 votes192 views1 answer
Oracle calculated column
SQL
7 votes199 views1 answer
Mysql iif
SQL
21 votes211 views4 answers
Add column mssql
SQL
0 vote186 views1 answer
What is between operator
SQL
2 votes238 views1 answer
Show max_allowed_packet mysql
SQL
0 vote215 views1 answer
How to set up an anonymous function to variable in swift
SQL
4 votes272 views1 answer
Postgresql change default value
SQL
0 vote214 views1 answer
SQLSTATE[01000]: Warning: 1265 Data truncated for column 'job_type' at row 1 (SQL: insert into
SQL
0 vote206 views1 answer
How to write if case in select query in select statement
SQL