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

Determine if oracle date is on a weekend?

1050

Where not exists in sql?

986

What is meant by cursor in sql?

1007

How consistent is the view of the data between and within multiple sessions, transactions or statements ?

2228

What are the advantages of pl sql?

1128

What is query execution plan in sql?

1194

Why we use triggers in mysql?

997

What is db journal file?

1073

Explain how can you save or place your msg in a table?

1037

Is sql port 1433 encrypted?

1036

what is the difference between sql and t-sql? : Transact sql

1100

How many types of primary keys are there?

1043

Any attempt to navigate programmatically to disabled form in a call_form stack is allowed?

1109

What is user defined functions?

990

What is sql keyword?

1008