N
Neville Lang
Hi all,
Though this question is probably more focussed on SQL, I thought I would
post it on this forum in case someone here can help me with an answer.
I have a single SQL table that has many columns and rows. What I want to do
is to take one column in a table, (one that contains short string data as an
attribute of the primary key data), and want to retrieve a list of the
values that are unique to that column.
For example, if I had 1,000 rows of data where in one column there were say
up to 20 unique string values assigned at random to each of those 1,000
rows,.how would I set up a query to retrieve those 20 (or so) unique values
in that one column without first knowing the range of values that are placed
there?
I must add that I am using a single table and that the values in the column,
mentioned above, are not located in any other table.
Any clues or hints on how I would construct such a query?
Regards,
Neville Lang
Though this question is probably more focussed on SQL, I thought I would
post it on this forum in case someone here can help me with an answer.
I have a single SQL table that has many columns and rows. What I want to do
is to take one column in a table, (one that contains short string data as an
attribute of the primary key data), and want to retrieve a list of the
values that are unique to that column.
For example, if I had 1,000 rows of data where in one column there were say
up to 20 unique string values assigned at random to each of those 1,000
rows,.how would I set up a query to retrieve those 20 (or so) unique values
in that one column without first knowing the range of values that are placed
there?
I must add that I am using a single table and that the values in the column,
mentioned above, are not located in any other table.
Any clues or hints on how I would construct such a query?
Regards,
Neville Lang