select in(1,10) from dual;

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

Question Posted / seshu

Answer Posted / seshu

select in(1,10)
from dual;

Is This Answer Correct ?

15 Yes

71 No

Please Help Members By Posting Answers For Below Questions

Why do we use sqlite?

537

What plvcmt and plvrb does in pl/sql?

881

What is a sql select statement?

574

What is data modelling in sql?

528

How does rowid help in running a query faster?

970

How do I view a sql trace file?

568

How do you pronounce sql?

552

Mention what is the function that is used to transfer a pl/sql table log to a database table?

486

How to create your own reports in sql developer?

544

how do you know the version of your mysql server? : Sql dba

508

What are the two types of exceptions.

638

What is clause?

613

Does sql full backup truncate logs?

533

Is sql dba a good career? : SQL DBA

539

What is full join in sql?

526