sql server queyr get last entries code example
Example: 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