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 a Mapplet?

1120

What is the purpose of a sql?

977

What is cursor in pl sql?

1116

what is row? : Sql dba

1226

Why self join is used in sql?

976

What is pragma in sql?

1080

What is a dirty read sql?

1138

Does group by remove duplicates?

1041

Which is better join or inner query?

1048

What is a procedure in pl sql?

1211

What is sql architecture?

1048

How do I count records in sql?

1006

What is the basic form of sql query?

943

Does truncate require commit?

974

How do you explain an index number?

1108