/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 vote171 views1 answer
Sql remove last x char
SQL
6 votes216 views5 answers
Oracle list tablespaces
SQL
0 vote230 views1 answer
Download mysql database to excel in android studio
SQL
0 vote175 views1 answer
Select in select sql
SQL
0 vote187 views1 answer
Insert using condition postgres
SQL
13 votes179 views6 answers
Current date sql
SQL
1 vote177 views1 answer
Mysql best tutorial for beginners
SQL
0 vote175 views1 answer
Mysql does collate nopad recognize space
SQL
1 vote205 views1 answer
Increase existing date in sql oracle
SQL
3 votes176 views1 answer
Oracle list user grants
SQL