/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 vote138 views1 answer
Delete mysql from mac
SQL
0 vote143 views1 answer
Get number of tables in database sql
SQL
3 votes125 views1 answer
MySQL DELETE JOIN
SQL
0 vote152 views1 answer
Foreign key multiple columns
SQL
0 vote148 views2 answers
Create-toys-table-with-toy_name-column
SQL
0 vote143 views1 answer
T-sql update table variale
SQL
0 vote150 views1 answer
Sql query tags
SQL
1 vote143 views1 answer
Flask sqlalchemy filter multiple conditions
SQL
1 vote166 views1 answer
How not to sort by average rating
SQL
19 votes165 views6 answers
Create table sqlite
SQL