SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;

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

Question Posted / nagesh

Answer Posted / nagesh

Is This Answer Correct ?

6 Yes

3 No

Please Help Members By Posting Answers For Below Questions

What is the advantage of index in sql?

915

What are user defined functions?

947

What is the source code of a program?

1002

What is equi join in sql?

1008

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.

7134

How to add, remove, modify users using sql?

978

What is string data type in sql?

1050

How you improve the performance of sql*loader? : aql loader

955

How many databases can sql express handle?

942

how can we take a backup of a mysql table and how can we restore it. ? : Sql dba

920

how many sql ddl commands are supported by 'mysql'? : Sql dba

956

Mention what pl/sql package consists of?

938

How do I upgrade sql?

947

What is tuple in sql?

1005

what is the bond code in materialized view?

2931