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

Answer Posted / manoj

select level from dual connect by level<=10

Is This Answer Correct ?    113 Yes 18 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

how to drop an existing index in mysql? : Sql dba

529


what is user defined functions? : Sql dba

541


What is online transaction processing (oltp)?

598


how many tables will create when we create table, what are they? : Sql dba

532


What is an index? What are the types of indexes? How many clustered indexes can be created on a table?

546






Is inner join faster than left join?

623


Can we use ddl commands in pl sql?

552


what is the difference between char and varchar data types? : Sql dba

528


Is hadoop a nosql?

567


How do you run a query?

579


Why we use stored procedure instead of query?

525


What is sql comments?

646


Which command is used to delete a package?

575


Why is nosql good?

585


How to add new employee details in an employee_details table with the following details

637