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

5 votes119 views1 answer
Sql asynchronous stored procedure call
SQL
5 votes110 views2 answers
Oracle list columns schema
SQL
0 vote125 views1 answer
Insert ip address in mysql
SQL
1 vote117 views1 answer
Drop table if exists oracle
SQL
0 vote151 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
0 vote130 views1 answer
Oracle allow space to user
SQL
0 vote161 views1 answer
Install postgresql 12 on debian 10
SQL
0 vote128 views1 answer
SQL isnumeric DB2
SQL
0 vote115 views1 answer
Clone table structure mysql
SQL
0 vote131 views1 answer
Oracle string substitution
SQL