/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

0 vote225 views1 answer
Convert int to varchar sql
SQL
0 vote206 views1 answer
Add super privilege mysql
SQL
0 vote276 views1 answer
How to make full text search dynamic in mysql
SQL
0 vote202 views1 answer
Postgresql update to unique
SQL
0 vote258 views1 answer
Inner join distinct
SQL
0 vote204 views1 answer
Hibernate dialect property xml for mysql 8
SQL
12 votes203 views2 answers
Delete all entries postgres
SQL
2 votes226 views2 answers
Mysql show table column comments sql
SQL
0 vote183 views1 answer
Mysql database is not starting in xampp
SQL
11 votes195 views1 answer
Mysql text type max length
SQL