If you create a new column and fill it with rnd(1), then sort on that field and pick the first 200 records, that should do it.
On Tue, Jul 11, 2006 at 03:30:25PM +0100, Sarah Williams wrote: > Hello, > > I have a table of 99769 records. I want to select out 200 of these at > random. Is there a way of doing this automatically in MapInfo rather > than generating a random number list and picking each record out > manually? I am using version 8. The table has a column of unique > numbers entitled ID. > > Thanks for any help > > Sarah Williams > GIS Officer > North Somerset Council > > > > ********************************************************* > PRIVACY AND CONFIDENTIALITY NOTICE > ********************************************************* > The information contained in this email transmission is intended by North > Somerset Council for the use of the named individual or entity to which it is > directed and may contain information that is privileged or otherwise > confidential. If you have received this email transmission in error, please > delete it from your system without copying or forwarding it, and notify the > sender of the error by reply email. > Any views expressed within this message or any other associated files are the > views and expressions of the individual and not North Somerset Council. > North Somerset Council takes all reasonable precautions to ensure that no > viruses are transmitted with any electronic communications sent, however the > Council can accept no responsibility for any loss or damage resulting > directly or indirectly from the use of this email or any contents or > attachments. > www.n-somerset.gov.uk > Main switchboard: 01934 888888 > ******************************************************** > > _______________________________________________ > MapInfo-L mailing list > [email protected] > http://www.directionsmag.com/mailman/listinfo/mapinfo-l _______________________________________________ MapInfo-L mailing list [email protected] http://www.directionsmag.com/mailman/listinfo/mapinfo-l
