Skip to content

Instantly share code, notes, and snippets.

@dergus

dergus/sql

Last active June 20, 2016 15:21
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dergus/9cd4f543a9ce705867f8c2b797586df5 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dergus/9cd4f543a9ce705867f8c2b797586df5 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql
Выходные SELECT *
FROM f_week AS week
INNER JOIN f_shop ON f_shop.id = week.shop
WHERE week.week
IN ( 0, 6 ) AND (SELECT COUNT(*) FROM f_week AS week2 WHERE week2.shop = week.shop AND week2.week > 0 AND week2.week < 6) = 0 GROUP BY week.shop
Будни
SELECT *
FROM f_week AS week
INNER JOIN f_shop ON f_shop.id = week.shop
WHERE week.week > 0 AND week.week < 6 AND (SELECT COUNT(*) FROM f_week AS week2 WHERE week2.shop = week.shop AND week2.week
IN ( 0, 6 )) = 0 GROUP BY week.shop
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment