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

Answer Posted / mkumar.it

select rownum from user_objects where rownum <= 10

Is This Answer Correct ?    71 Yes 20 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a boolean in sql?

707


Can we rollback after truncate?

754


What does partition by mean in sql?

691


Can you do multiple joins in sql?

730


What is a unique key?

776






What does count (*) do in sql?

737


what is self-join? : Sql dba

756


What are the topics in pl sql?

704


what is sql server agent? : Sql dba

772


What is column?

723


Explain scalar functions in sql?

772


How to add, remove, modify users using sql?

745


What is the difference between clustered and non-clustered index in sql?

733


What are tuples in sql?

779


What are the basic techniques of indexing?

782