At 15:08 -0600 2/8/02, José Angel Blanco Linares wrote: >Hi, everybody > >How can I get a numeric column from a SQL SELECT statement? >I mean, with a SELECT get something like this > >ColNum or ColNum > 1 10 > 2 11 > 3 12 > 4 13 > 5 14 > 6 15 > ... ... > >Some time ago, somebody wrote a sample that do exactly what I need. In fact, I >took that sample and saved it to my HD, but i can't find it, hehehe.
Do you mean you want to number the output rows from a query? Do you mean you want to specify a beginning and ending number and generate a series containing all the numbers from the beginning to the end? Or something else? > >TIA > >______________________________________ >José Angel Blanco Linares >Depto Servicios de Apoyo Académico >Centro de Enseñanza Técnica Industrial >3641-3250, ext: 266 --------------------------------------------------------------------- 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
