Hello Nick, Does ROWNUM exist in MySQL?
Kind reagrds Emmanuel > -----Original Message----- > From: Nick [mailto:[EMAIL PROTECTED]] > Sent: 19 January 2002 20:41 > To: Shankar Unni > Cc: [EMAIL PROTECTED] > Subject: [OT] Re: Understanding throughput with JDBC > > > > > With Oracle, the *only* solution is to issue a query for the whole > > resultset and scroll through it - it doesn't support anything > *like* the > > LIMIT concept, though I suppose you *could* imitate it with > "WHERE ROWNUM < > > blah". > > With Oracle, you can retrieve a part of a result set by using inline > views: > > SQL> select d.c1,d.c2,d.c3 > 2 from (select c1,c2,c3,rownum c4 from foo order by c3) d > 3 where d.c4 >=15 and d.c4 <= 19 > 4 / > > C1 C2 C3 > ---------------- ---------------- ---------------- > 115 30 15 > 116 32 16 > 117 34 17 > 118 36 18 > 119 38 19 > > Not as elegant as I would like, but it works. > > -- > Nick > Email: [EMAIL PROTECTED] > > > > > --------------------------------------------------------------------- > Please check "http://www.mysql.com/Manual_chapter/manual_toc.html"; before > posting. To request this thread, e-mail [EMAIL PROTECTED] > > To unsubscribe, send a message to the address shown in the > List-Unsubscribe header of this message. If you cannot see it, > e-mail [EMAIL PROTECTED] instead. > --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
