-->-----Original Message-----
-->From: Comcast [mailto:[EMAIL PROTECTED]
-->Sent: Friday, September 12, 2003 11:03 AM
-->To: [EMAIL PROTECTED]
-->Subject: SELECT only unique records
-->
-->I am sure this is a slam-dunk, but I am new to this and stumped ...
-->thanks.
-->I have the following statement, but I need it to pull only unique
-->listings - I get repeated items.
-->
-->SELECT state_ID FROM financial_master WHERE category_ID = '1'
If you need UNIQUE listings look up DISTINCT / GROUP BY SQL statements
Example
SELECT DISTINCT(state_ID) from financial_master WHERE category_ID='1';
-->
-->
-->
- Dathan Vance Pattishall
- Sr. Programmer and mySQL DBA for FriendFinder Inc.
- http://friendfinder.com/go/p40688
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
