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 are triggers and its types?

1120

Determine if oracle date is on a weekend?

1089

What is form and report?

1053

Where is all the data on the internet stored?

1057

What is pl sql block structure?

1095

can a stored procedure call itself or recursive stored procedure? How much level sp nesting is possible? : Sql dba

1048

How to execute a stored procedure?

1157

Show the cursor attributes of pl/sql.

1101

What is record data type?

981

What is sql lookup?

970

Is mariadb a nosql database?

1098

How do you update f as m and m as f from the below table testtable?

1930

Does sql profiler affect performance?

1048

What are the different ways to optimize a sql query?

990

How many types of triggers are there in pl sql?

1119