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
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
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'
]
Sent: Friday, September 12, 2003 2:03 PM
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
: 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'
--
MySQL General Mailing
Try
SELECT DISTINCT state_ID FROM financial_master WHERE category_ID = '1'
Roger
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: SELECT only unique records
I am sure this is a slam-dunk, but I
---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
At 01:02 PM 9/12/2003, Comcast wrote:
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'
SELECT DISTINCT
will not.
DISTINCTROW is a synonym for DISTINCT.
2 points !
-Original Message-
From: Comcast [mailto:[EMAIL PROTECTED]
Sent: Friday, September 12, 2003 2:03 PM
To: [EMAIL PROTECTED]
Subject: SELECT only unique records
I am sure this is a slam-dunk, but I am new to this and
stumped