/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

4 votes115 views2 answers
Host '192.168.43.100' is not allowed to connect to this MySQL server
SQL
3 votes113 views1 answer
Convert sqlite table to pandas dataframe
SQL
0 vote116 views1 answer
Sql server query database space available
SQL
0 vote137 views1 answer
Cube oracle
SQL
2 votes122 views1 answer
Sql server case sensitive search
SQL
0 vote114 views5 answers
Linq cheat sheet
SQL
14 votes141 views5 answers
Set password for postgres user ubuntu
SQL
0 vote103 views1 answer
Fetch second word from a string in ms sql
SQL
0 vote128 views1 answer
How much space does sql server take per row
SQL
15 votes109 views2 answers
How to drop database name in postgresql
SQL