RE: SQL Question

Dennis,

Something like the following could work, but depending on the size of the
file you're working with, could be really s-l-o-w.

select * from
  (select ...field_list.....
     from filex
     where ......
     order by ......) a
where rrn(a)<=10

Eric DeLong
Sally Beauty Company
MIS-Sr. Programmer/Analyst
940-898-7863 or ext. 1863



-----Original Message-----
From: Dennis Munro [mailto:DMunro@badgerminingcorp.com]
Sent: Wednesday, September 26, 2001 5:13 PM
To: Midrange List (E-mail)
Subject: SQL Question


I've got an Access database that uses the following statement & I am
wondering if there is a way to do the same with SQL from the AS/400.
Running V4R5M0 & one cum back.

"Select Top 10 QQTEST.THID From QQTEST" with a Where & Order By clause.

Thanks - Dennis.

Dennis Munro

"I love deadlines.  I especially like the whooshing sound they make as they
go flying by."  Dilbert's Words Of Wisdom:

Badger Mining Corporation
www.badgerminingcorp.com
dmunro@badgerminingcorp.com
(920) 361-2388

_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@midrange.com
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/cgi-bin/listinfo/midrange-l
or email: MIDRANGE-L-request@midrange.com
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.