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

Answer Posted / pramod kumar behera

select level from dual connect by level <=10;

Is This Answer Correct ?    7 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how would concatenate strings in mysql? : Sql dba

570


What are different types of triggers?

555


What is auto increment feature in sql?

616


how can we know the number of days between two given dates using mysql? : Sql dba

543


Can you join a table to itself?

540






What is an emotional trigger?

516


Why we use join in sql?

526


Explain what is a database?

645


What is a loop in sql?

564


How do I count records in sql?

514


Why do we use function in pl sql?

553


Is sql easier than java?

522


What is sql and also describe types of sql statements?

562


What is a sql instance vs database?

572


What is a rank in sql?

534