Andrew,
There's 2 options both requiring the addition of a new column (as float) to
your table that is then updated.
Version 1 is to update the new column with the rowid number thus:
Update Mytable Set Mycol = rowid
and then
Select * from Mytable where Mycol mod N into ran
f Of Andrew Tracey
Sent: Tuesday, January 17, 2006 9:16 AM
To: MapInfo-L@lists.directionsmag.com
Subject: [MI-L] SQL Queries
I currently have a table with 79000 points in it. Does anyone have a query or
know how to pick out a random sample of the data (say every 100 or every 1000
records)
Thank
Hi Andrew
You've probably had a number of replies already but here goes
To select every "n"th record from a table using SQL, type
rowid mod(n)=0
... into the "Where Condition" area of the dialog.
Hope this makes sense and is of some assistance.
Regards
Tony Maber - Certified Map
FB Engineering AB
Södra Förstadsgatan 26
211 43 Malmö
Tel: 040-660 25 50
Mobil: 0705-27 60 27
Fax: 040-660 25 99
[EMAIL PROTECTED]
www.fbe.se
"Andrew Tracey" <[EMAIL PROTECTED]>
Sänt av: [EMAIL PROTECTED]
2006-01-17 09:15
Till
Kopia
Ärende
[MI-L] SQL Queries
I curren
lnRandNum = lnRandNum + 100
Loop
HTH
Terry
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] On Behalf Of Andrew
Tracey
Sent: 17 January 2006 09:05
To: Terry McDonnell
Subject: [MI-L] SQL Queries
I currently have a table with 79000 points in it. Does anyone have a
query o
I currently have a table with 79000 points in it. Does anyone have a query or
know how to pick out a random sample of the data (say every 100 or every 1000
records)
Thanks in advance
Andrew Tracey
Information Support Officer
Corporate Information
Corporate Development
South Tyneside Council
Wes
u need.
Fletcher James
President
Levit & James, Inc.
703-771-1549
[EMAIL PROTECTED]
www.levitjames.com
-Original Message-
From: Carlo Fazio [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 01, 2005 6:44 PM
To: mapinfo-l@lists.directionsmag.com
Subject: MI-L SQL queries
When using th
When using the asterisk (*) symbol to select all records in an SQL query, is it
possible to select all columns from one table rather than both tables? I know I
can select columns individually but there are too many for selecting
individually. The dialogue box won't let me select all of them.
C
Hi Richard
Easy. I am new as well to MapInfo, but I am getting there. This is what you do: click
Query>SQL Select, then on the dialog box
Select Colums: *
>From Tables: Table Name you want to select from
Where Condition: Company Name like "Richard%"
Group by olumns:
Order by Columns:
into t
al Information & IT moved from Rugaardsvej 55, 5000
Odense C to Odensevej 95, 5260 Odense S.
Please note our new telephone, direct and telefax numbers.
> -Original Message-
> From: Richard Hill [mailto:[EMAIL PROTECTED]
> Sent: Wednesday, January 14, 2004 7:07 AM
> To:
Hello Folks,
This is a straight forward request, but I am not yet familiar with SQL.
I have a Mapinfo table from which I want to select all records in which
a specific name appears in the "Company Name" column. However (and this
is the limit of my understanding of SQL) the name could be (for exam
Geological Survey
California Department of Conservation
Phone: (916) 323-8192
[EMAIL PROTECTED]
-Original Message-
From: Clifton Stephens [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 6:39 AM
To: MIL
Subject: MI-L SQL Queries
I'm having a bit of trouble writing queri
I'm having a bit of trouble writing queries in MI.
Perhaps I'm trying to get it to give me too much. Does
anyone out there have a library of sample queries they
would be willing to share? I need a little help with
what I can and can't ask in different situations and
probably a lot of help with my s
Are there electronic or paper publications that contain what I guess you
could call generic SQL queries, with an explanation of what problem each
query aims at resolving? I'm particularly interested in predictive
modelling in archaeology, but am not sufficiently mathematically literate to
constru
14 matches
Mail list logo