i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 42717 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / pramod kumar behera
select rownum from dual connect by level <=10;
| Is This Answer Correct ? | 6 Yes | 0 No |
Post New Answer View All Answers
What is the max nvarchar size?
what are the types of join and explain each? : Sql dba
Compare sql & pl/sql
How do we use distinct statement? What is its use?
What are the query optimization techniques?
What view means?
Why is normalization important?
Why do we need databases?
What is the current version of sql?
what does it mean to have quoted_identifier on? : Sql dba
how can we find the number of rows in a table using mysql? : Sql dba
how to create a table index in mysql? : Sql dba
Differences between Oracle 9i and 10g (Probably in terms of SQL and PL/SQL)?
What is secondary key?
How do I run a sql trace?
