advanced code snippet search

Posted By

jfoucher on 12/04/09


Tagged


Versions (?)

frase del dia grefusa

 / Published in: MySQL
 
Expand | Embed | Plain Text 
  1. SELECT * FROM frasedeldia__ganadores fg WHERE fecha IN (SELECT MIN(fecha) AS minf FROM frasedeldia__ganadores WHERE fecha LIKE '2009-11%' GROUP BY DAY(fecha))

Report this snippet  

Comments

RSS Icon Subscribe to comments
Posted By: jfoucher on December 7, 2009

SELECT * FROM completafrase__ganadores WHERE fecha IN (SELECT MIN(fecha) AS minf FROM completafrase__ganadores WHERE fecha LIKE '2009-11%' GROUP BY DAY(fecha)) GROUP BY mail ORDER BY puntos DESC LIMIT 10

You need to login to post a comment.