By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,705 Members | 1,845 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,705 IT Pros & Developers. It's quick & easy.

select distinct criteria?

P: n/a
Is there a way of specifying how select distinct works? In other words I
don't want it to work on every column, just a selection of them.

What I'm really looking for is ways of removing duplicates where a few of
the columns may be different.

Cheers,
Chris
Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
C L Humphreys wrote:
Is there a way of specifying how select distinct works? In other words I
don't want it to work on every column, just a selection of them.

What I'm really looking for is ways of removing duplicates where a few of
the columns may be different.


If the columns are static to be distict on, create another query with those
columns and make it display distinct and add that query into your current
query.
Nov 12 '05 #2

P: n/a
"U N Me" <un**@together.com> wrote in message
news:3F***************@together.com...
C L Humphreys wrote:
Is there a way of specifying how select distinct works? In other words I don't want it to work on every column, just a selection of them.

What I'm really looking for is ways of removing duplicates where a few of the columns may be different.
If the columns are static to be distict on, create another query with

those columns and make it display distinct and add that query into your current
query.


Sounds a good idea, but you'll have to run me through it!
I've got my query with distinct on 3 columns, but how do I 'add' that to my
current query?

Cheers,
Chris
Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.