Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 2101 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Do we need to rebuild index after truncate?
i have a word ***********hello********world******. I require a o/p **********hello world**********, Need to delete the middle stars.
What are functions in sql?
What are database links used for?
What is Overloading of procedures ?
Explain what is sql?
Why trigger is used in sql?
What is the difference between the conventional and direct path loader? : aql loader
How to run sql statements through the web interface?
what are the differences among these table level lock modes - IN SHARE MODE, IN SHARE UPDATE MODE, IN EXCLUSIVE MODE ?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
What is the maximum number of triggers,can apply to a single table?
-
Oracle (3259) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
