Rownum exists of a sort with the limit clause. Rowid does not exist all at.
Tony ----- Original Message ----- From: "Emmanuel van der Meulen" <[EMAIL PROTECTED]> To: "MySQL Java List" <[EMAIL PROTECTED]>; "MySQL General List" <[EMAIL PROTECTED]>; "Nick" <[EMAIL PROTECTED]> Sent: Sunday, January 20, 2002 12:46 PM Subject: RE: [OT] Re: Understanding throughput with JDBC > 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 > > --------------------------------------------------------------------- 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
