Re: how to select distinct records

"Wally" <wallyraju_at_gmail.com> wrote:
> i have a table like one shown below
>
> start_date | end_date | traveller
> -----------------------------------------------
> 1/1/2005 | 10/10/2005 | a
> 1/1/2005 | 10/10/2005 | b
> 5/1/2005 | 11/10/2005 | c
> 2/1/2005 | 6/11/2005 | d
> 3/1/2005 | 11/23/2005 | e
> 3/1/2005 | 11/23/2005 | f
>
> I need to write a query that would give me only one record for any
> distinct date range. My results should be something like
>
> select distinct start_date, end_date, (first traveller found for that
> start_date and end_date) from table;
>
> start_date | end_date | traveller
> -----------------------------------------------
> 1/1/2005 | 10/10/2005 | a
> 5/1/2005 | 11/10/2005 | c
> 2/1/2005 | 6/11/2005 | d
> 3/1/2005 | 11/23/2005 | e

select start_date, end_date, min(traveller) ..... group by start_date, end_date;

Xho

-- 
-------------------- http://NewsReader.Com/ --------------------
Usenet Newsgroup Service                        $9.95/Month 30GB