Postgres Queries - RobertCzaja/it-offers-api GitHub Wiki

Duplicated values

SELECT name, COUNT(*) AS occurrences
FROM company
GROUP BY name
HAVING COUNT(*) > 1;

select
    o.created_at,
    o.company_id,
    c.*
from company c
left join offer o on c.id = o.company_id
where name in ('emagine Polska','NFQ','BNY','EPAM Systems','Tamago','Sparkbit spółka z o. o.','Kyotu Technology')
order by o.created_at desc

SELECT name, COUNT(*) AS occurrences
FROM category
GROUP BY name
HAVING COUNT(*) > 1;

---

select * from company where id in (
'ec107532-7e1a-4e4a-b79f-ba44077f7a2d'
'84b7474b-499a-43e5-aea7-fe176d453a6e'
'ae80e50d-29fd-4490-8d2b-d19c785b5c2a'
'3ca71ef7-a2e4-45b7-803f-31b500d5b892'
'e8c8ebd5-2f75-453b-bd00-a3a2c296fd2e'
'6cc7594d-5c34-4887-ae0e-7f06a9e2fd56'
'172df13c-a73d-4f63-bc0b-7e6785e2633e')