/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 vote239 views1 answer
How do you insert boolean to postgresql
SQL
2 votes226 views3 answers
How to pass password mysql command line
SQL
0 vote233 views1 answer
Character count sql
SQL
0 vote238 views1 answer
How to get data from 2 database
SQL
0 vote218 views2 answers
Drop check constraint in ms sql
SQL
1 vote236 views1 answer
Tsql get beginning of year
SQL
3 votes224 views3 answers
Stop mysql ubuntu
SQL
0 vote222 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
41 votes259 views6 answers
Alter table add column in SQL Server
SQL
1 vote231 views1 answer
Woocommerce mysql price table
SQL