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 difference between primary key and unique key? : Sql dba

1031

What programs use sql?

994

What is ttitle and btitle?

1061

Can we create table in function?

960

What is sap sql anywhere?

1066

Is it possible to create the following trigger: before or after update trigger for each row?

1280

What is exception? What are the types of exceptions?

1066

How do I run a sql query in pgadmin 4?

957

How many types of indexes are there in sql?

978

Mention what does plv msg allows you to do?

1107

Why is normalization important?

1019

How do I remove sql developer from windows 10?

1099

Is natural join same as inner join?

924

How to take user input in pl sql?

1157

What are the operators in sql?

1021