select rownum from employees;

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

Question Posted / ameer mujahid

Answer Posted / ameer mujahid

Is This Answer Correct ?

0 Yes

19 No

Please Help Members By Posting Answers For Below Questions

What is PL/SQL Records?

1177

what is msql? : Sql dba

981

What is the use of prepared statement?

1005

What are the events on which a database trigger can be based?

1178

Explain the steps needed to create the scheduled job?

1033

How can we implement rollback or commit statement in a trigger?

1022

what is the difference between cluster and non cluster index? : Sql dba

1015

Is time a data type in sql?

896

Why query optimization is needed?

916

What kind of join is join?

955

How do I make sql search faster?

988

What sql does db2 use?

969

How to display the current date in sql?

1066

How do I quit sql?

945

Where are my tempfiles, I don't see them in v$datafile or dba_data_file?

993