Re: SQL selectie: starten vanaf bepaalde rij

Article View: be.comp.programming

Article #1283

Back to be.comp.programming Previous Next

#1283

From: Jan Meskens
Date: Sun, 26 Jun 2005 15:47

10 lines
1275 bytes

> Je moet de handleiding van je dbms raadplegen, als ik me niet vergis bv:
> 
> postgresql: limit
> mysql: limit
> mssql: top

Met mysql is het zeker iets zoals :  LIMIT 0, 10 

Waarbij 0 het startrecord is en 10 het aantal records vanaan het
startrecord

Technical Details

Message-ID: <pan.2005.06.26.15.47.34.866364@pandora.be>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!hwmnpeer01.lga!hwmedia!newsreader.com!feed7.newsreader.com!newsreader.com!nntp.telenet.be!blueberry.telenet-ops.be.POSTED!0f7c3a53!not-for-mail

References: <j2Ite.125969$GO3.6834229@phobos.telenet-ops.be> <d989u7$j8r$1@ikaria.belnet.be>

Show Full Headers

Complete Article Headers

X-Google-Thread: fcea4,97531372e490016e
X-Google-Attributes: gidfcea4,public
X-Google-Language: DUTCH,ASCII-7-bit
Path: arc1-ca.pugleaf.net!g2news1.google.com!news3.google.com!news.glorb.com!hwmnpeer01.lga!hwmedia!newsreader.com!feed7.newsreader.com!newsreader.com!nntp.telenet.be!blueberry.telenet-ops.be.POSTED!0f7c3a53!not-for-mail
From: Jan Meskens <janmeskens@pandora.be>
Subject: Re: SQL selectie: starten vanaf bepaalde rij
User-Agent: Pan/0.14.2.91 (As She Crawled Across the Table (Debian GNU/Linux))
Message-ID: <pan.2005.06.26.15.47.34.866364@pandora.be>
Newsgroups: be.comp.programming
References: <j2Ite.125969$GO3.6834229@phobos.telenet-ops.be> <d989u7$j8r$1@ikaria.belnet.be>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
Lines: 10
Date: Sun, 26 Jun 2005 17:47:35 +0200
NNTP-Posting-Host: 213.118.8.145
X-Trace: blueberry.telenet-ops.be 1119800865 213.118.8.145 (Sun, 26 Jun 2005 17:47:45 CEST)
NNTP-Posting-Date: Sun, 26 Jun 2005 17:47:45 CEST

Reply to Parent Message