Select Distinct

Thread View: borland.public.interbase.sql

3 messages

[T] Back to Threads [V] Tree View [G] Group Articles

3 total messages Started by Will Bonner-May Mon, 02 Dec 2002 11:46

#11270

Author: Will Bonner-May
Date: Mon, 02 Dec 2002 11:46

9 lines
1239 bytes

Is it possible to specify multiple distinct fields in a select statement
I.e:

Select Distinct(UserID), Distinct(TopicID), UserName From TopicEval


Thanks in advance,

Will Bonner-May

Re: Select Distinct

#11271

Author: Bj�rge S�ther
Date: Mon, 02 Dec 2002 11:56

13 lines
1431 bytes

"Will Bonner-May" <willbm@knowledgeuk.com> skrev i melding
news:3deb480e@newsgroups.borland.com...
> Is it possible to specify multiple distinct fields in a select statement
> I.e:
>
> Select Distinct(UserID), Distinct(TopicID), UserName From TopicEval

Select Distinct UserID, TopicID, UserName From TopicEval

...this will return all combinations of the 3 fields in the table.
--
Bj�rge S�ther
bjorge@hahaha_itte.no

Re: Select Distinct

#11273

Author: Will Bonner-May
Date: Mon, 02 Dec 2002 12:20

20 lines
1653 bytes

Thanks for your help Bj�rge!


"Bj�rge S�ther" <bjorge@hahaha_itte.no> wrote in message
news:3deb48f4@newsgroups.borland.com...
> "Will Bonner-May" <willbm@knowledgeuk.com> skrev i melding
> news:3deb480e@newsgroups.borland.com...
> > Is it possible to specify multiple distinct fields in a select statement
> > I.e:
> >
> > Select Distinct(UserID), Distinct(TopicID), UserName From TopicEval
>
> Select Distinct UserID, TopicID, UserName From TopicEval
>
> ...this will return all combinations of the 3 fields in the table.
> --
> Bj�rge S�ther
> bjorge@hahaha_itte.no
>
>

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads