use sequence. automatically increments.

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

Question Posted / pushkar

Answer Posted / pushkar

Is This Answer Correct ?

10 Yes

27 No

Please Help Members By Posting Answers For Below Questions

What do you understand by case manipulation functions?

1082

What is left join in sql?

1093

Which command is used to call a stored procedure?

1055

The select into statement is most often used to create backup copies of tables or for archiving records?

1120

what is the difference between blob and text? : Sql dba

1064

What are the different types of database management systems?

1037

What is the purpose of primary key?

1073

What is sql analyzer?

1060

What is embedded sql in db2?

1061

How is pl sql different from sql?

1144

How many subqueries can be nested in a statement?

1042

What is right join in sql?

1158

How do you know if a relationship is 2nf?

995

How do I partition a table in sql?

1209

what is a database transaction? : Sql dba

1258