SHARE
TWEET

Untitled

a guest Apr 23rd, 2019 49 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. SELECT * FROM(
  2. SELECT NAME, COUNT('X')VECES FROM
  3. (SELECT ALBUM AS NAME,PLAYDATETIME FROM PLAYBACKS JOIN (DISCS JOIN SINGLES USING(ISVN)) USING(ISVN)
  4. 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)
  5. --WHERE (PLAYDATETIME>SYSDATE-1)
  6. GROUP BY NAME
  7. ORDER BY VECES DESC)
  8. WHERE ROWNUM<11
  9. ;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top