At 12:59 +0300 9/12/02, Fam. Tarniceru wrote: >Dear Sirs, > >How can I handle with this situation? >I need a special column in a SELECT statement - with LIMIT clause -, that >can index my rows from 1 upward in the result set, and I don't know how to >make it in MySQL. It is known that Oracle have a special function (RowNum) >for this problem.
Not sure what you mean. Result sets don't have indexes, unless you select them into a table that has an index. If you mean that you want the result to have an indexable column that you can use for a further selection constraint, then I suggest that you select the result into a temporary table and run a second query on that table. >Best regards > >Adrian Tarniceru --------------------------------------------------------------------- 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
