i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 42628 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / srinivas
select rownum rn from (select 1 from dual group by
cube(1,2,3,4,5)) where rownum <=10
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is hibernate and its relation to sql?
Is sqlexception checked or unchecked?
how can we destroy the session, how can we unset the variable of a session? : Sql dba
what is blob? : Sql dba
What are sql triggers used for?
Is sql better than excel?
What does count (*) mean in sql?
What is a subquery in sql?
what is 'mysqlimport'? : Sql dba
how to delete duplicate rows from a join tables(I have three tables on that join) how do you know which join is need to be used? The select statement I have is: SELECT gc_skill_type.skill_type, gc_area_tec.area, gc_technology.technology, gc_technology.id_technology, gc_area_tec.id_area_tec FROM gc_skill_type, gc_area_tec, gc_technology WHERE gc_area_tec.id_skill_type (+) = gc_skill_type.id_skill_type AND gc_technology.id_area_tec (+) = gc_area_tec.id_area_tec order by gc_skill_type.skill_type asc, gc_area_tec.area asc, gc_technology.technology asc
What is a database trigger?
What are the parts of a sql statement?
What does (*) mean in sql?
What is difference sql and mysql?
What are the types of variables use in pl sql?
