codehaven - php snippets - coding help
Generic filters
Exact matches only
    • octopus energy discount code

    Query – One of each colour, highest ID of each – ‘Group By’ and ‘Order By’

    14th March 2014

    MySql

    mysql codehaven category

    This selected one of each colour, showing the highest id of each, where the website was called Codehaven.

    1
    2
    3
     
    SELECT * FROM (SELECT * FROM table1 WHERE `website` LIKE '%Codehaven%' ORDER BY id DESC) AS t GROUP BY colour
     

    Was this code snippet helpful?

    RSS Latest Snippets
    LINKS
    A Repository of Code Snippets in many Programming Languages:-

    PHP – JQUERY
    CSS – MYSQL
    WORDPRESS – JAVASCRIPT
    WOOCOMMERCE – HTML

    © 2022 CODEHAVEN