/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 vote312 views1 answer
Mysql disable query caching
SQL
0 vote311 views1 answer
Php delete database
SQL
0 vote312 views2 answers
Mysql regexp match word
SQL
0 vote384 views1 answer
Org.h2.jdbc.jdbcsqlsyntaxerrorexception: syntax error in sql statement
SQL
0 vote322 views2 answers
Postgresql change user role grant
SQL
0 vote323 views1 answer
Database xml sql
SQL
0 vote348 views1 answer
Select distinct after join
SQL
8 votes327 views1 answer
Oracle create datafile
SQL
0 vote313 views1 answer
Reset keys in sql
SQL
0 vote314 views1 answer
Initcap in sql
SQL