Re: SQL selecting records

From: Happy <allan_at_livvy80.freeserve.co.uk>
Date: Mon, 12 Feb 2001 22:23:33 -0000
Message-ID: <969ntr$mfk$1@newsg2.svr.pol.co.uk>

SELECT *
FROM table_name
WHERE column = criteria
AND rownum < 6;

should return first five rows

Cheers
Allan

"Alan" <alwong_at_123infosys.com> wrote in message news:lNYh6.1859$Vp.200052_at_newsread2.prod.itd.earthlink.net...
> I am trying to only get the first 5 records out of tables that met certain
> criteria. Can I get these 5 records without getting all the records that
> met certain criteria? Thanks.
>
>
>
Received on Mon Feb 12 2001 - 16:23:33 CST