/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

5 votes178 views1 answer
JBDC
SQL
0 vote196 views1 answer
What is database username and password in mysqliconnect
SQL
1 vote181 views1 answer
Rails run native ssql query
SQL
5 votes158 views1 answer
Alter table default value mysql
SQL
41 votes274 views6 answers
Alter table add column in SQL Server
SQL
3 votes212 views5 answers
No module named 'MySQLdb'
SQL
1 vote201 views1 answer
Insert value to new table by joining 2 different tables
SQL
1 vote172 views2 answers
Sqlalchemy.exc.OperationalError: (sqlite3.OperationalError) unable to open database file
SQL
0 vote196 views1 answer
Laravel migration sql dump
SQL
0 vote188 views1 answer
Change magento database url usimg musql
SQL