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

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.

7347

What is the difference between microsoft access and sql?

1023

What is a temporal table?

930

Why partition by is used in sql?

1038

How can I get the number of records affected by a stored procedure?

1065

How to order siblings in oracle hierarchy queries?

1047

What is a null value?

1143

What is a temporal data type?

1052

What is sql comments?

1074

Can cursors be part of a trigger body?

1641

How many sql core licenses do I need?

944

What are the methods of filing?

935

Why do we use set serveroutput on?

965

How to pipe multiline string to isql?

1005

Write a sql query to find the names of employees that begin with ‘a’?

1014