SQL Query to print 1-n numbers?

Ranch Hand

Posts: 60

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

for(int i =0; i<n i++)
We can print 1-n numbers on the console by using above loop.

In the sameway How I can display 1-n numbers on SQL console by using SQL Query..?
Can any body help me regarding this?>

Thanks & Regards
KITTU

Jeanne Boyarsky

author & internet detective

Posts: 42173

937

I like...

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Krishnareddy,
Just the numbers? I don't know - SQL isn't intended for that.

If you trying to have a column with row numbers for a query, that's a different story. Oracle provides the rownum keyword for that.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Krish Yeruva

Ranch Hand

Posts: 60

posted 16 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Hi Jeanne,
Even Iam thinking the same.

I have googling some sites and I found something like this:

a)SELECT * FROM (SELECT LEVEL FROM dual CONNECT BY LEVEL < 10);

I haven't verified whether it is right or wrong(Because currently I didn't have the setup for that)?
Can you please let me know if you find something?

Thanks & Regards
KITTU

Power corrupts. Absolute power xxxxxxxxxxxxxxxx is kinda neat.

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders