/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 vote165 views1 answer
Set column width in sqlplus
SQL
2 votes175 views1 answer
How to delete view in sql
SQL
0 vote171 views1 answer
Xampp increame mysql speed
SQL
3 votes165 views3 answers
Your password does not satisfy the current policy requirements
SQL
19 votes171 views4 answers
Rename database in sql
SQL
0 vote172 views1 answer
Supprimer les valeur d'une table mysql
SQL
0 vote143 views1 answer
Procedures and functions in pl/sql
SQL
1 vote182 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
0 vote163 views1 answer
Mysql drop trigger
SQL
0 vote168 views1 answer
Sqlite closes value
SQL