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 is write ahead logging in sql server?

1053

Explain the difference between drop and truncate commands in sql?

1054

What is restrict in sql?

1120

What is update query?

984

What is rtm in testing?

1117

What are joins in sql?

1045

Is join and inner join the same?

1004

How to create a menu in sqlplus or pl/sql?

1127

What are types of exception?

922

What is informix sql?

980

How to change a value of the field ‘salary’ as 7500 for an employee_name ‘john’ in a table employee_details?

1438

Why do we use joins?

1040

What is union and union all keyword in sql?

1043

What are character functions in sql?

940

What is scalar function in sql?

1041