select 1,2,3,4,5,6,7,8,9,10 from dual;

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

Question Posted / rashmi raju

Answer Posted / rashmi raju

Is This Answer Correct ?

3 Yes

20 No

Please Help Members By Posting Answers For Below Questions

How do you write a complex sql query?

1056

how to create a table index in mysql? : Sql dba

1051

how to add a new column to an existing table in mysql? : Sql dba

1063

how many sql dml commands are supported by 'mysql'? : Sql dba

1113

Explain dml and ddl?

983

Which is faster truncate or drop?

1043

How do I view output in sql developer?

1075

how to install mysql? : Sql dba

1100

How to create your own reports in sql developer?

1010

What is clustered index sql?

982

What are the basic techniques of indexing?

1057

Is it possible for a table to have more than one foreign key?

1028

What is sqlerrd?

966

How does a covering index work?

953

How can use stored procedures in sql?

1134