/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 vote203 views1 answer
How to query without duplicate rows in sql
SQL
2 votes198 views1 answer
Query to check cpu utilization in oracle database
SQL
22 votes216 views3 answers
How to join three tables in sql using joins
SQL
12 votes199 views2 answers
Update column data type postgres
SQL
13 votes181 views3 answers
Sql online code
SQL
0 vote199 views1 answer
How to tell if i have lactose intolerance
SQL
0 vote189 views1 answer
Sqlserver now
SQL
0 vote183 views1 answer
Mysql workbench download for iinux mint 19.3
SQL
0 vote199 views1 answer
Ms sql filter all sympbol
SQL
0 vote191 views1 answer
Sql script to get a type task on jira datbase for 12 months
SQL