Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT * FROM(
- SELECT NAME, COUNT('X')VECES FROM
- (SELECT ALBUM AS NAME,PLAYDATETIME FROM PLAYBACKS JOIN (DISCS JOIN SINGLES USING(ISVN)) USING(ISVN)
- WHERE (PLAYDATETIME>'30/12/18' AND PLAYDATETIME<'01/01/19')) --SE PUEDE UTILIZAR LA FECHA ACTUAL PERO NO DEVOLVERÍA NINGUN RESULTADO, AQUI DEFINIMOS UN INTERVALO/DIA (31/12/2018)
- --WHERE (PLAYDATETIME>SYSDATE-1)
- GROUP BY NAME
- ORDER BY VECES DESC)
- WHERE ROWNUM<11
- ;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement