Problem with SQL

From: <smnayeem_at_my-dejanews.com>
Date: Sat, 13 Mar 1999 03:55:09 GMT
Message-ID: <7ccniq$mci$1@nnrp1.dejanews.com>

Hi, in SQL scripts, when i want to display say only the first 15 rows of a sorted list i cant use the rownum because rownum only returns the raw row number. does anyone know how to do this relative addressing,

eg if i want to display only the top 15 names of the following query what condition would i give :

select id, name, duration, total
from bill
where ?

i would greatly appreciate anyones help on this. thanks.

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Fri Mar 12 1999 - 21:55:09 CST