i want to display 1 to 10 numbers using one select statement.
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
What is sql server and ase?
Explain ttitle and btitle.
What is application trigger?
What does trigger mean in psychology?
How do I filter in sql profiler?
What does the acronym acid stand for in database management?
What are data types in pl sql?
What are the benefits of pl sql?
How does one use sql*loader to load images, sound clips and documents? : aql loader
How to check if a column is nullable before setting to nullable?
What is composite data type in pl sql?
How sql query is executed?
Write the order of precedence for validation of a column in a table? I. Done using database triggers. Ii. Done using integarity constraints
Can a key be both primary and foreign?
What is user in sql?