Hi Steve,
The following query should produce what you want:
Select * from YourTable where rowid mod 10 =3D 0
BRGDS
Mircea Baila
MobiFon, Romania
E-mail: [EMAIL PROTECTED]
Web: www.connex.ro
-----Original Message-----
From: Mike Stein [mailto:[EMAIL PROTECTED]]
Sent: 19 March, 2002 10:47 AM
To: [EMAIL PROTECTED]
Subject: MI-L RE: SQL
Hi all,
I am trying to select a number of records from a field within my table =
which
represent kilometre points along a route. These records range from 0 - =
430.
I would like to select every tenth record i.e. 0; 10; 20 etc, so that I =
can
limit the visual clutter on screen.
If anyone can help it would be most appreciated.
Mike Stein
GIS Project Assistant
RSK/ENSR Ltd.
Tel: +44 (0)1928 726006
Fax: +44 (0)1928 725633
mailto:[EMAIL PROTECTED]
http://www.rsk.co.uk
---------------------------------------------------------------------
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
****************************************************************
The content of this communication is classified as Mobifon SA Romania =
Confidential and Proprietary Information.The content of this =
communication is intended solely for the use of the individual or entity =
to whom it is addressed and others authorized to receive it. If you are =
not the intended recipient you are hereby notified that any disclosure, =
copying, distribution or taking any action in reliance on the contents =
of this information is strictly prohibited and may be unlawful. If you =
have received this communication in error, please notify us immediately =
by responding to this communication then delete it from your system. We =
appreciate your assistance in preserving the confidentiality of our =
correspondence. Thank you.
Prezentul mesaj constituie o Informatie confidentiala si este =
proprietatea exclusiva a MobiFon S.A.. Mesajul se adreseaza numai =
persoanei fizice sau juridice mentionata ca destinatara, precum si altor =
persoane autorizate sa-l primeasca. In cazul in care nu sunteti =
destinatarul vizat, va aducem la cunostinta ca dezvaluirea, copierea, =
distribuirea sau initierea unor actiuni pe baza prezentei informatii =
sunt strict interzise si atrag raspunderea civila si penala. Daca ati =
primit acest mesaj dintr-o eroare, va rugam sa ne anuntati imediat, ca =
raspuns la mesajul de fata, si sa-l stergeti apoi din sistemul dvs. =
Apreciem si va multumim pentru sprijinul acordat in pastrarea =
confidentialitatii corespondentei noastre.=20
_______________________________________________________________________
List hosting provided by Directions Magazine | www.directionsmag.com |
To unsubscribe, send e-mail to [EMAIL PROTECTED] and
put "unsubscribe MapInfo-L" in the message body.
