/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

2 votes345 views1 answer
Postgresql transaction
SQL
0 vote354 views1 answer
Postgres execute multiple sql file from command line
SQL
0 vote337 views1 answer
How to fetch highest score in minimum time using mysql
SQL
3 votes398 views3 answers
1396(hy00) mysql error
SQL
0 vote335 views1 answer
Mysql begin statement
SQL
6 votes348 views1 answer
What is where clause in sql
SQL
2 votes328 views1 answer
T-sql remove all non-alphanumeric characters from a string
SQL
0 vote355 views1 answer
Kill a pid redshift
SQL
0 vote379 views1 answer
Node-pre-gyp ERR! Tried to download(403): https://mapbox-node-binary.s3.amazonaws.com/sqlite3/v3.1.13/node-v72-win32-x64.tar.gz
SQL
0 vote348 views1 answer
How to change the field size of an existing column
SQL