i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 44868 Views
- HCL, Nyros, Oracle, I also Faced
- E-Mail Answers
Answer Posted / nagesh
SELECT * FROM EMP WHERE ROWNUM<=10 ORDER BY ENO;
| Is This Answer Correct ? | 6 Yes | 3 No |
Post New Answer View All Answers
Please Help Members By Posting Answers For Below Questions
What are the two different parts of the pl/sql packages?
What are the different types of joins in sql?
Is inner join same as self join?
What are the properties of a transaction?
What are the parts of a basic sql query?
How do you remove duplicate records from a table?
What is delimiter sql?
Why is nosql good?
Why is %isopen always false for an implicit cursor?
Is and as keyword in pl sql?
How do you break a loop in pl sql?
What jobs use sql?
Explain the rollback statement?
Describe sql comments?
What is date functions?
