How to get last element sql

How to get last row of table in sql

mysql> select *from getLastRecord ORDER BY id DESC LIMIT 1;

Source: tutorialspoint.com

How to get last element sql

	Select Distinct names.xyz
       From nameList names
       LEFT JOIN nameList idNum
       ON idNum.xyz > names.xyz AND idNum.xyz IS NOT NULL
       WHERE idNum.xyz IS NULL

Similar codes

18 votes208 views3 answers
Mysql number format
SQL
-1 vote187 views1 answer
How to format tables in sqlplus
SQL
1 vote238 views1 answer
Oracle show execution plan
SQL
0 vote185 views1 answer
Count column of tables psql
SQL
11 votes215 views1 answer
Oracle view source
SQL
1 vote222 views1 answer
Name of today sql
SQL
0 vote207 views2 answers
SQLSTATE[42S22]: Column not found: 1054 Unknown column 'created at' in 'field list' (SQL: insert into `categories` (`category_name`, `user_id`, `created at`) values (sea fish, 1, 2021-09-24 04:17:31))
SQL
1 vote213 views1 answer
Sql server insert into temp table
SQL
1 vote274 views2 answers
Begin transaction sql
SQL
2 votes204 views1 answer
Enum in SQL Server
SQL