i want to display 1 to 10 numbers using one select statement.
- 18 Answers
- 42460 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
What is nested table in pl sql?
What is string join?
Define the select into statement.
What is partition by in sql?
What do you mean by stored procedures?
what is a composite primary key ? : Sql dba
explain the difference between delete , truncate and drop commands? : Sql dba
Table 1: col1 Timestamp ---------------- 01-mar-2012 11:12:46 Table 2: col2 Timestamp -------------------- 01-mar-2012 11:12:10 01-mar-2012 11:11:23 Write a query to display a row with table2 col2 value less than tabl1 col1 value. Maximum timestamp value previous to table1 col1 value. Display a result as: Col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10
What is the difference between python and sql?
What can you do with pl sql?
Mention what is the plv (pl/vision) package offers?
What is column?
Explain the uses of control file.
what are properties of a transaction? : Sql dba
what is a primary key? : Sql dba
