/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 vote152 views1 answer
Apex for oracle 11g
SQL
2 votes159 views1 answer
Oracle drop sequence if exists
SQL
1 vote111 views1 answer
Convert money to varchar sql server
SQL
0 vote114 views1 answer
Mariadb list tables
SQL
3 votes152 views3 answers
How to set up an auto incrementing id db browser
SQL
1 vote147 views1 answer
Rails run native ssql query
SQL
0 vote136 views1 answer
Postgresql create user roles
SQL
7 votes160 views6 answers
Mysql group concat
SQL
6 votes141 views2 answers
Mysql concatenate two columns into one
SQL
8 votes166 views1 answer
Oracle add datafile to tablespace
SQL