Advertisement
akozhomka

Untitled

May 13th, 2021
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
MySQL 0.22 KB | None | 0 0
  1. SELECT spa.hash
  2.      , spa.storage_id
  3.      , COUNT(spa.ID) AS q
  4.      , GROUP_CONCAT(spa.ID) AS ids
  5. FROM yii_doc.supplier_price_avalaible spa
  6. WHERE spa.storage_id = 53
  7. GROUP BY spa.hash
  8.        , spa.storage_id
  9. HAVING q > 1;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement