/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

3 votes189 views1 answer
Show index table
SQL
0 vote276 views1 answer
SqlMessage: "Table 'Friends' already exists",
SQL
16 votes179 views1 answer
Sqlserver add column to table
SQL
6 votes183 views4 answers
How to remove unique key in mysql
SQL
0 vote252 views1 answer
Month mysql
SQL
-1 vote137 views1 answer
Mysql how to set update or create
SQL
1 vote204 views1 answer
Mysql remove last empty newline
SQL
1 vote210 views1 answer
Increase date by one day in sql oracle
SQL
1 vote178 views1 answer
How to delete record sql delphi
SQL
50 votes296 views6 answers
Sql count duplicate rows
SQL