mysqlSelect last record from group
SELECT id, name FROM table WHERE id IN ( SELECT max(id) FROM table GROUP BY name )ctrl + cSELECT id, namecolumns to select | tabletable name to select from (definition) |
WHERE id INselect only certain ids, defined by subquery | SELECT max(id) FROM table GROUP BY namesubqyery will return last (maximum) ids for each unique |
More of Mysql
- Insert/update multiple rows in single query
- Disable ONLY_FULL_GROUP_BY mode
- How to find my.cnf config file
- Truncate all tables in a specific database
- What is the MEDIUMTEXT column max size (length) in Mysql
- Get largest tables list
- How to find duplicate varchar/text column values in table
- What is the TINYINT column max value and size in Mysql
- Make a pager (limit / offset) select query
- What is the LONGTEXT column max size (length) in Mysql
See more codes...