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
- 1729 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Is crud a cuss word?
what is the difference between a web-garden and a web-farm? : Sql dba
what is a composite primary key ? : Sql dba
Write a query to get last 10 records from the table.
What is the difference between python and sql?
what is the difference between blob and text? : Sql dba
what is view? : Sql dba
how are mysql timestamps seen to a user? : Sql dba
how to get @@error and @@rowcount at the same time? : Sql dba
What is a database link?
What is bind reference and how can it be created?
How can you load microsoft excel data into oracle? : aql loader
-
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)
