/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

10 votes216 views3 answers
How to fetch first 5 characters in sql
SQL
2 votes219 views1 answer
Sqlserver: how to search a table used in particular stored procedure
SQL
1 vote222 views1 answer
Mysql add fields
SQL
0 vote219 views2 answers
How to generate a unique random number in mysql
SQL
0 vote214 views1 answer
Many rows to 1 string mysql
SQL
0 vote230 views1 answer
Postgresql auto increment not working
SQL
1 vote222 views1 answer
Alter table column size oracle
SQL
14 votes219 views1 answer
Oracle new column
SQL
0 vote260 views1 answer
Kimball data warehouse sql calendar
SQL
0 vote228 views1 answer
Logtash mysql cofiguration file
SQL