[Date Prev][Date Next][Thread Prev][Thread Next]
[Author Index] [Date Index] [Thread Index]
[SQR-USERS Info] [SQRUG Home Page]

RE: [sqr-users] SQL question

Hi Bindu:

SQL> select rownum -1 from temp_table
  2  where rownum < 12;

 ROWNUM-1
---------
        0
        1
        2
        3
        4
        5
        6
        7
        8
        9
       10

11 rows selected.
this will work provided if you have more than 100 records in a table.

Thanks,
Ven Garlapati 

-----Original Message-----
From: Vallabhu, Bindu [mailto:Bindu.Vallabhu@staples.com]
Sent: Wednesday, January 15, 2003 11:34 AM
To: 'sqr-users@sqrug.org'
Subject: [sqr-users] SQL question


Hi All,
Is there a way we can generate a list of numbers in SQL.
the list should include all numbers from 0 to 100. 
Thank you,
Bindu

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users