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

0 vote271 views1 answer
Call procedure in wordpress
SQL
3 votes257 views2 answers
Oracle sql truncate table
SQL
11 votes290 views3 answers
How to get last row of table in sql
SQL
0 vote255 views1 answer
How many columns can be used for creating index?
SQL
0 vote220 views2 answers
Illuminate\Database\QueryExceptionSQLSTATE[HY000] [2002] No such file or directory
SQL
0 vote284 views1 answer
Varchar2 length in oracle
SQL
0 vote254 views1 answer
Format the money fied with comma in international system using sql
SQL
11 votes268 views2 answers
Set default column value sql
SQL
9 votes279 views1 answer
Mysql check date range
SQL
13 votes266 views2 answers
Mysql order by multiple columns
SQL