MySQL Forums
Forum List  »  Spanish

Mostrar resultado de MAX y COUNT
Posted by: Ariel Diaz
Date: June 18, 2021 10:05PM

Buenas, tengo una tabla con 2 campos (aciertos,estado)

Lo que quiero es mostrar el máximo acierto y a lado contar cuantos aciertos son

SELECT MAX(aciertos) FROM matriz WHERE habilitado='SI'

Options: ReplyQuote


Subject
Views
Written By
Posted
Mostrar resultado de MAX y COUNT
459
June 18, 2021 10:05PM


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.