Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT y.idShow,y.c12,y.c13,
- y.strFileName
- FROM episode_view Y
- INNER JOIN (
- SELECT
- c12,c13,idShow, COUNT(*) AS CountOf
- FROM episode_view
- GROUP BY idShow,c12,c13
- HAVING COUNT(*)>1
- ) dt ON y.c12=dt.c12 AND y.c13=dt.c13 AND y.idShow=dt.idShow;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement