/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 vote192 views1 answer
Except in sql
SQL
0 vote165 views1 answer
Console output pl sql
SQL
0 vote128 views1 answer
Sql count how many times a value appears
SQL
0 vote173 views1 answer
Oracle shrink table
SQL
0 vote232 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote165 views1 answer
Set column width in sqlplus
SQL
0 vote207 views1 answer
Search In the Data using ObjectName
SQL
1 vote180 views2 answers
How to check if sql query is correct online
SQL
2 votes168 views1 answer
How to find constraints on a table in oracle
SQL
9 votes325 views2 answers
Current date in postgresql minus 1 day
SQL