/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 vote290 views1 answer
Mysql how to set update or create
SQL
0 vote370 views1 answer
Sql server separar numeros por comas miles
SQL
0 vote362 views7 answers
Les jointures sql server
SQL
0 vote369 views1 answer
Ms sql print more than 1 variable
SQL
1 vote414 views1 answer
How not to sort by average rating
SQL
1 vote418 views2 answers
Install sql server management studio ubuntu
SQL
1 vote376 views1 answer
Oracle avg
SQL
-1 vote374 views1 answer
Module operator in oracle sql
SQL
-2 votes360 views1 answer
How to open database
SQL
0 vote371 views3 answers
Duplicate row mysql
SQL