How to select distinct values from a column in Mapbasic?

Question

I have a table in a mapinfo .tab file. Is there any way to select distinct values from the column?

I tried :-

SELECT distinct (some_column) from table_name into temp_table

But this query would select all values. I wanted to select only distinct value from that column. Is there any way to achieve it?

Peter Horsbøll Møller · Accepted Answer · 2012-10-24 08:34:07Z

7

MapInfo Pro does not support the Distinct keywork, unfortunately. However you can get to the same result just be grouping your result by the column

Select some_column from table_name into temp_table Group By some_column

answered Aug 15 '11 at 8:22

7,20417 silver badges26 bronze badges

add a comment |

dblancer · Accepted Answer · 2012-10-18 20:52:27Z

1

It appears if you simply group by column name, the results only come up once ( as per a distinct) Just tested in MapInfo 10.0

answered Oct 18 '12 at 20:52

dblancer

191 bronze badge

Welcome to our site! Could you perhaps provide an explicit example of what the command looks like and the output it would give for a simple dataset? – whuber Oct 19 '12 at 13:56

add a comment |

2 Answers 2