Interested to Buy Any Domain ? << Click Here >> for more details...
How many rows will return from dual table?
- 4 Answers
- 12001 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
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 are local and global variables and their differences? : Sql dba
What is the use of triggers?
What is a primary key? Explain
Can we have two clustered index on a table?
Which software is used for pl sql programming?
What is the difference between microsoft sql and mysql?
Are null values same as that of zero or a blank space?
What is mutating error?
What is scope of pl sql developer in future?
what is the difference between nested subquery and correlated subquery?
How to get list of all tables from a database?
what is the difference between where clause and having clause? : Sql dba
Define select, insert, create, delete, update, drop keywords
What is the difference between local and global temporary table?
