select last row in sql
SELECT TOP 1 * FROM Table ORDER BY ID DESCselect last row in sql
SELECT TOP 1 * FROM Table ORDER BY ID DESCsql 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 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
;Copyright © 2021 Codeinu
Forgot your account's password or having trouble logging into your Account? Don't worry, we'll help you to get back your account. Enter your email address and we'll send you a recovery link to reset your password. If you are experiencing problems resetting your password contact us
