mysqlSelect first record from group
SELECT id, name FROM table WHERE id IN ( SELECT min(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 min(id) FROM table GROUP BY namesubqyery will return first (minimum) ids for each unique |
More of Mysql
- Select last record from group
- What is the TINYINT column max value and size in Mysql
- Create myisam tables dump without locking tables
- Disable ONLY_FULL_GROUP_BY mode
- Insert/update multiple rows in single query
- What is the MEDIUMINT column max value and size in Mysql
- What is the LONGTEXT column max size (length) in Mysql
- What is the TINYTEXT column max size (length) in Mysql
- Replace string with regex
- Create dump of a database to a filename with date
See more codes...