select in(1,10) from dual;

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

Question Posted / seshu

18 Answers
47733 Views
HCL, Nyros, Oracle, I also Faced
E-Mail Answers

Answer Posted / seshu

select in(1,10)
from dual;

Is This Answer Correct ?

15 Yes

71 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

Can we debug stored procedure?

1032

What does trigger mean in slang?

1073

What is natural join in sql?

1003

How do I create an index in word?

1039

What does (+) mean in sql joins?

1074

Is primary key always clustered index?

1029

Explain the difference between sql and mysql.

1068

If i can use sys.check_constraints to display my constraints from my database using sql server 2005, how can i display then if i am using sql server 2000????

4017

What are conditional predicates?

1065

what is the difference between undefined value and null value? : Sql dba

1110

Which query operators in sql is used for pattern matching?

976

What is cartesian join in sql?

1139

What are the advantages of sql? Explain

1114

How to run sql*plus commands in sql developer?

1166

How many commands are in sql?

1077