sql get last id

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

1SELECT MAX(id) FROM <tablename>

1	Select Distinct names.xyz
2       From nameList names
3       LEFT JOIN nameList idNum
4       ON idNum.xyz > names.xyz AND idNum.xyz IS NOT NULL
5       WHERE idNum.xyz IS NULL
6