MySQL Forums
Forum List  »  Portuguese

Select por sexo
Posted by: Sandro ACosta
Date: June 13, 2011 06:43AM

Preciso fazer um select em uma tabela que tem 200 homens e 60 mulheres, sendo que cada membro tem uma média pré-defnida.
O limite de itens retornados em cada pesquisa tem que ter no mínimo 2 mulheres, podendo ter mais, mas nunca menos.

SELECT media, id, nome, sexo, status
FROM tabelamembros
WHERE status = "1"
ORDER BY media ASC
LIMIT 0,10

Options: ReplyQuote


Subject
Views
Written By
Posted
Select por sexo
5948
June 13, 2011 06:43AM
2268
June 13, 2011 07:11AM


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.