Answer Posted / arul
Structured Query Language
| Is This Answer Correct ? | 4 Yes | 0 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
Is pl sql different from sql?
How does sql developer connect to oracle database?
how to concatenate two character strings? : Sql dba
How can I change database name in sql?
What is the difference between database trigger and stored procedure?
what is the difference between a having clause and a where clause? : Sql dba
What is a full join sql?
What is dml and ddl?
What does count (*) mean in sql?
How do I turn a list into a table?
List the different type of joins?
Explain the purpose of %type and %rowtype data types?
What are all ddl commands?
What is foreign key and example?