Interested to Buy Any Domain ? << Click Here >> for more details...
i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 48272 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
Is sql a scripting language?
Why truncate is faster than delete?
Can a foreign key be a duplicate?
What is trigger explain it?
How to get help at the sql prompt?
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
How many types of triggers exist in pl/sql?
What is offset in sql query?
Is mariadb a nosql database?
What is dynamic sql in pl sql?
How do I view tables in sql developer?
Is a table valued function object?
Mention what does the hierarchical profiler does?
what are date and time data types? : Sql dba
What is autocommit sql?
