select rownum from emp where rownum<=10;

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

Question Posted / raghuramu

Answer Posted / raghuramu

select rownum from emp
where rownum<=10;

Is This Answer Correct ?

13 Yes

10 No

Please Help Members By Posting Answers For Below Questions

what is sp_pkeys? : Transact sql

1149

How do you copy a table in sql?

1063

What plvcmt and plvrb does in pl/sql?

1307

What is right join sql?

957

How do you rename a table in sql?

1100

What does bitemporal mean?

1059

What is the difference between a primary key and a clustered index?

982

How do I start sql profiler?

989

Can you sum a count in sql?

995

How does a self join work?

1101

Why do we need cursors in pl sql?

1071

Can we insert data in view?

953

Advantages and disadvantages of stored procedure?

1118

What are the different sql commands?

1065

What are the ways on commenting in a pl/sql code?

1124