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
- 0 Answers
- 1720 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
how to sort records in sql?
What is delimiter in pl sql?
What is the difference between stored procedure and view?
How can you load microsoft excel data into oracle? : aql loader
How to Declare Fixed Length String Value In PL SQL
What is the best free sql database?
Does truncate need commit?
What types of commands can be executed in sql*plus?
What are the steps for performance tuning.
Is primary key clustered or nonclustered?
What are different types of refreshment techniques of materialised view
What are different types of triggers?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
