MySQL Forums
Forum List  »  Newbie

need help for mysql query
Posted by: andrisp
Date: April 19, 2005 03:51AM

I'm trying to make query which takes data from table like SELECT MAX do, but I want such a query who takes only those rows who got one of the collumn fields equal and have maximal mysql_num_rows.

for example, there is a collumn:

USER_ID
2055
2034
2022
2055
2034
2034
2022

I want the query to take only 2034, because rows with this value ar more than other rows with other values.

sorry for my english - it's not my native.

Thank you.

Options: ReplyQuote


Subject
Written By
Posted
need help for mysql query
April 19, 2005 03:51AM


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.