/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 vote181 views1 answer
Create sqlite database in laravel
SQL
60 votes313 views6 answers
Add column in sql
SQL
0 vote137 views0 answer
SQL
0 vote178 views1 answer
Call function sql oracle
SQL
1 vote189 views1 answer
ORA-01950
SQL
0 vote171 views1 answer
View acl table oracle
SQL
0 vote185 views1 answer
Watch mysql command line
SQL
7 votes190 views1 answer
Oracle pagination query offset
SQL
1 vote170 views2 answers
Populate sql table with random data
SQL
4 votes172 views1 answer
Sql quote in string
SQL