applying DISTINCT to only one field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a query
SELECT DISTINCT a,b,c
I need DISTINCT to be applied to fiels c only
What would be syntax for that?
 
I'm not sure I understand what you're looking for.

SELECT DISTINCT a, b, c

is going to return a recordset that has one row for each distinct
combination of a, b and c. For any given a and b combination, you'll only
get (at most) 1 instance of each possible c value. You will see specific
values of c multiple times, but only if a and b are different.

Can you give an example of exactly what you're looking for? If you only want
to see a specific value of c once, how do you want to choose which of the
multiple a and b values to display?
 
Thanks, Douglas, for asking me a good question - you are pight, perhaps I do
not need that. Let me think
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SELECT DISTINCT query 8
Selecting Distinct Memo Fields 1
Select Distinct query 8
NOT IN and Sub Query 2
perform INNER JOIN on query results 2
COUNT and DISTINCT in Access 3
Select distinct does not group rows 8
how do i perform a Count(Distinct) query for 2 different column va 1

Back
Top