[LUGOS-PROG] SQL poizvedba

[Bostjan Muller]

* On 26-09-01 at 15:47 janez.grad at eunet.si (janez.grad at eunet.si) wrote:
+----Here quoted text begins----+
> Zivio!
> 
> Imam en zacetniski problem pri poizvedbi v SQL bazi.
> Ko sestavim SQL stavek z ukazom SELECT mi SQL streznik
> vrne cca 10000 zapisov, ki ustrezajo pogoju. Zanima me
> kako bi moral sestaviti SQL stavek, da bi nazaj dobil samo
> del zapisov (recimo od 5000-ega zapisa do 5100-tega zapisa,
> ki ustreza poizvedbi z ukazom SELECT).
> 
> LP Janez.
+----and here the quote ends----+
Imas slucajno kako numericno razvrstitev v tabeli? Like id ali kaj podobnega:
potem naredi 
SELECT * FROM tabela WHERE id>=5000 AND id<=5100;

LP

B.
-- 
[*] Boštjan Müller - neonatus at neonatus.net - http://neonatus.net/~neonatus [*]
[*]    GPG/PGP key -> finger: neonatus at neonatus.net, DSA id: 0x9B2FF108    [*]
[*] Celular: +386(0)41243189, Powered by Debian GNU/LiNUX - ICQ #:7506644  [*]
		  Press to test. *click* Release to detonate.