Code: Select all
SELECT Id, Version, FirstName, LastName FROM people WHERE Id='0';Code: Select all
+----------+---------+-----------+--------------+
| Id | Version | FirstName | LastName |
+----------+---------+-----------+--------------+
| 0 | 0 | Old | Name |
| 0 | 1 | New | Name |
+----------+---------+-----------+--------------+Code: Select all
SELECT Id, MAX(Version), FirstName, LastName FROM people WHERE Id='0' GROUP BY Id;Code: Select all
+----------+--------------+-----------+----------+
| Id | MAX(Version) | FirstName | LastName |
+----------+--------------+-----------+----------+
| 0 | 1 | Old | Name |
+----------+--------------+-----------+----------+