/SQL/PS5

PS5

    SELECT
    product_name,
    list_price,
    category_id
FROM
    production.products p1
WHERE
    list_price IN (
        SELECT
            MAX (p2.list_price)
        FROM
            production.products p2
        WHERE
            p2.category_id = p1.category_id
        GROUP BY
            p2.category_id
    )
ORDER BY
    category_id,
    product_name;

Source: sqlservertutorial.net

Ps5

So, your cultured i see.

Ps5

STAY PURE WITH THE PC BOIIII

-1

Similar codes

1 vote139 views2 answers
Regex starts with
SQL
10 votes139 views2 answers
Mysql alter add foreign key
SQL
0 vote157 views1 answer
Trigger stock phpmyadmin
SQL
4 votes93 views1 answer
And or sql order of operations
SQL
1 vote131 views1 answer
Get url of cpanel database hostname
SQL
0 vote150 views1 answer
Reindex mssql table
SQL
2 votes213 views1 answer
Postgresql group by month and year
SQL
0 vote148 views1 answer
Query to remove duplicate rows from a table
SQL
0 vote135 views1 answer
Psql attribute cannot login
SQL
1 vote153 views2 answers
This month mysql where
SQL