Welcome! Log In Create A New Profile

Advanced

Query question

Posted by Antonino Neri.pcs.crosspost 
Forum List Message List New Topic
Antonino Neri.pcs.crosspost
Query question
December 05, 2008 02:50PM
Hello everyone, I would like to ask if is it possible to create a query that selects from a table only the unique elements. I got a table with this situation: a, b, c, a, d, e, c, f, b... How can I retrive only: a, b, c, d, e, f?


Regards,
Antonino

Message forwarded from pcsoft.us.windev
Reply Quote
M. Beaven
Re: Query question
December 05, 2008 02:55PM
Hi Antonio- there is a setting in the query editor to "Delete the Duplicates". Perhaps this will help for your case?

Regards,

-Marc
Reply Quote
Firetox
Re: Query question
December 05, 2008 06:27PM
Hello

you have several solution

select distinct myCol from my table

or

select myCol from myTable
Group by myCol

regards
Reply Quote
Javier.pcs.crosspost
Re: Query question
December 11, 2008 05:07PM
Select a,b,c,d From FileName

Message forwarded from pcsoft.us.windev
Reply Quote
Newer Topic Older Topic
Author:

Your Email:


Subject:
Spam prevention:
Please, enter the code that you see below in the input field. This is for blocking bots that try to post this form automatically. If the code is hard to read, then just try to guess it right. If you enter the wrong code, a new image is created and you get another chance to enter it right.
Message: