/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 vote133 views1 answer
Mysql sql.gz
SQL
5 votes123 views1 answer
List foreign key oracle
SQL
1 vote126 views1 answer
Drop df constraint sql server
SQL
0 vote142 views1 answer
Postgresql replace html tags from string
SQL
1 vote151 views1 answer
Oracle extract minute from date
SQL
0 vote135 views1 answer
Grant privileges mysql to database 1064
SQL
0 vote130 views1 answer
Get all employees if name ends with in sql
SQL
0 vote130 views2 answers
Sql having multiple conditions
SQL
1 vote125 views1 answer
Access denied for user 'root'@'localhost' python sql-connect error
SQL
0 vote138 views1 answer
Manage Database in MySQL
SQL