Re: SELECT only unique records

[Bruce Feist]

Petre Agenbag wrote:

How can one select unique rows based on a set of fields

select distinct state_ID from financial_master where category_id='1'
only returns rows based on the uniqueness of one field.
what if there is another field that COMBINED with state_ID forms a
unique row; how can one search for those?
 

Select distinct on both:

select distinct stateID, cityID
...
Bruce Feist



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]