CODEWITHSUNDEEP
mysql
Sarvesh Tiwari
Sarvesh Tiwari

Reputation: 111

how to get first value of duplicate value in mysql

I have a table where I am having duplicates value also.

From that table, I want to get the first value of duplicate values via an order by id desc.

I am using below query to find count

select product_sku, quantity 
from catalog_product_store_inventory 
where ax_store_id=999 
ORDER BY id DESC;

From this query, I get the all duplicates value.

I hope I made my query clear.

I am very new to MySQL.

Upvotes: 0

Views: 805

Answers (1)

sbrbot
sbrbot

Reputation: 6447

What means duplicates in your case? Duplicates according to what product_sku or both product_sku,quantity - this should be used in GROUP BY clause:

SELECT product_sku,quantity
FROM catalog_product_store_inventory c
JOIN (
     SELECT MAX(id) id
       FROM catalog_product_store_inventory
      GROUP BY product_sku
    ) m ON c.id = m.id

ORDER BY id DESC means that you want last ID from group and this one is MAX.

Upvotes: 1

Related Questions