SELECT LEVEL FROM DUAL CONNECT BY LEVEL<=9;

i want to display 1 to 10 numbers using one select statement.

Question Posted / subrat

Answer Posted / subrat

SELECT LEVEL
FROM DUAL
CONNECT BY LEVEL<=9;

Is This Answer Correct ?

0 Yes

0 No

Please Help Members By Posting Answers For Below Questions

How many rows can sqlite handle?

1121

How to display the current date in sql?

1083

Enlist the characteristics of pl/sql?

1807

What is multiple partition?

973

Is record in oracle pl sql?

971

How do you delete data from a table?

1048

What is the difference between an inner join and an outer join?

1029

what is normalization? : Sql dba

1089

How do I make my sql query run faster?

948

What is equi join in sql?

1083

What is the difference between delete and truncate commands?

1045

How do you delete duplicates in sql query using rowid?

950

What is the difference between a query and a report?

982

Can a varchar be a primary key?

1013

Which join condition can be specified using on clause?

958