Select duplicate values in table

[Lumir]

Hi all,

I need select duplicates in table - there is column with numbers example - 354, 355, 356, 356, 357, 358, 358... and i want select the same numbers 356, 356, 358, 358... i dont know how to do...

Can someone help me pls?

Thanks

[Ross Nixon]

An SQL query similar to the following will identify duplicates. It tells you how many instances of each value there are in the column.
Select ColumnName, Count(*) from TableName group by ColumnName order by count desc into Dup_Count_qry

Ross

[ktgcad]

Select * column name "no"

Will list all of them

-------- Original message --------
From: mapi...@googlegroups.com
Date:2016/06/23 12:02 (GMT+05:30)
To: MapInfo-L
Subject: [MI-L] Select duplicate values in table

Hi all,

I need select duplicates in table - there is column with numbers example - 354, 355, 356, 356, 357, 358, 358... and i want select the same numbers 356, 356, 358, 358... i dont know how to do...

Can someone help me pls?

Thanks

--
--
You received this message because you are subscribed to the
Google Groups "MapInfo-L" group.To post a message to this group, send
email to mapi...@googlegroups.com
To unsubscribe from this group, go to:
http://groups.google.com/group/mapinfo-l/subscribe?hl=en
For more options, information and links to MapInfo resources (searching
archives, feature requests, to visit our Wiki, visit the Welcome page at
http://groups.google.com/group/mapinfo-l?hl=en

---
You received this message because you are subscribed to the Google Groups "MapInfo-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email to mapinfo-l+...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.

[Lumir]

Thank you Ross, its working perfect

Dňa štvrtok, 23. júna 2016 10:59:44 UTC+2 Ross Nixon napísal(-a):