MySQL Forums
Forum List  »  Spanish

Re: mysql: problemas con select count
Posted by: William Chiquito
Date: March 20, 2008 08:20PM

Hola jokin,

Una opciĆ³n es una subconsulta (subquery).
SELECT tabledev.palabra, COUNT(*) AS numero, tabledev.id
FROM (SELECT palabra, id FROM busquedas WHERE palabra = 'platano' ORDER BY id DESC) AS tabledev
GROUP BY tabledev.palabra;

Options: ReplyQuote


Subject
Views
Written By
Posted
4458
March 20, 2008 07:47AM
Re: mysql: problemas con select count
1790
March 20, 2008 08:20PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.