Re: SELECT only unique records

2003-09-15 Thread 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 sear

RE: SELECT only unique records

2003-09-14 Thread Petre Agenbag
gt;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 > >> > >> > &

RE: SELECT only unique records

2003-09-12 Thread Paul DuBois
will work, but UNIQUE 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

Re: SELECT only unique records

2003-09-12 Thread Dwight Trumbower
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 state

RE: SELECT only unique records

2003-09-12 Thread Dathan Vance Pattishall
-->-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.

RE: SELECT only unique records

2003-09-12 Thread Roger Davis
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 > >

RE: SELECT only unique records

2003-09-12 Thread Fortuno, Adam
L 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'

RE: SELECT only unique records

2003-09-12 Thread Dan Greene
om: 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 ... thanks. > I have the following statement, but I ne

SELECT only unique records

2003-09-12 Thread Comcast
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'