/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 vote161 views1 answer
Sql table to store status
SQL
0 vote200 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote240 views1 answer
Get total and distict row diff in sql
SQL
1 vote212 views1 answer
Sql avg group by
SQL
2 votes203 views1 answer
Oracle drop table free up space
SQL
1 vote211 views2 answers
Test sqlsrv connection
SQL
6 votes208 views6 answers
Count mysql
SQL
0 vote232 views1 answer
Mysql relationships between tables
SQL
0 vote231 views2 answers
Insert data mysql with cmd
SQL
0 vote172 views3 answers
Mysql calculate age from date of birth
SQL