/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

11 votes157 views1 answer
Mysql text type max length
SQL
5 votes159 views3 answers
Truncate function in sql oracle
SQL
-1 vote231 views1 answer
Get month and year from date in mysql sequelize
SQL
0 vote166 views1 answer
Look at running processes redshift
SQL
0 vote234 views1 answer
Trigger
SQL
0 vote215 views1 answer
Replace null value within column mysql
SQL
36 votes274 views6 answers
Change column data type sql
SQL
6 votes146 views2 answers
Mysql concatenate two columns into one
SQL
1 vote172 views1 answer
Mysql dump specific tables
SQL
0 vote155 views1 answer
Create table database in psql
SQL