Interested to Buy Any Domain ? << Click Here >> for more details...
How many rows will return from dual table?
- 4 Answers
- 11804 Views
- Fujitsu, I also Faced
- E-Mail Answers
Answer Posted / sen
SELECT ROWNUM, LEVEL
FROM DUAL
CONNECT BY LEVEL < 5;
| Is This Answer Correct ? | 9 Yes | 2 No |
Post New Answer View All Answers
what are the disadvantages of mysql? : Sql dba
How global cursor can be declare with dynamic trigger ?
Mention what does the hierarchical profiler does?
Can sql developer connect to db2?
What are the two types of periodical indexes?
How to write a query to show the details of a student from students table whose
What is the use of <> sql?
What is a mutating table and a constraining table?
discuss about myisam index statistics collection. : Sql dba
what are ddl statements in mysql? : Sql dba
How do I run a script in sql developer?
What is the difference between explicit and implicit cursors in oracle?
What does pl sql stand for?
can sql servers linked to other servers like oracle? : 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
