select rownum from emp where rownum<=10;

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

Question Posted / raghuramu

18 Answers
48232 Views
HCL, Nyros, Oracle, I also Faced
E-Mail Answers

Answer Posted / raghuramu

select rownum from emp
where rownum<=10;

Is This Answer Correct ?

13 Yes

10 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you use collections in procedure to return the resultset?

2281

mention if it is possible to import data directly from t-sql commands without using sql server integration services? If yes, what are the commands? : Transact sql

1091

How do you break a loop in pl sql?

1100

column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.

7477

Is mariadb nosql?

1088

List the various privileges that a user can grant to another user?

1090

What is the trigger in sql?

1001

What is a pl/sql block?

1325

What does t sql mean?

1000

What are the two different parts of the pl/sql packages?

1138

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

1238

How to connect a sql*plus session to an oracle server?

1173

What is an implicit commit?

1100

Is sql a microsoft product?

994

What does the hierarchical profiler does?

1125