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
- 2115 Views
- I also Faced
- E-Mail Answers
No Answer is Posted For this Question
Be the First to Post Answer
Is stored procedure faster than query?
How to Execute a Package in PL/SQL.?
What does a pl/sql package consist of?
What are different joins used in sql?
What is varchar data type in sql?
Is there a way to automate sql execution from the command-line, batch job or shell script?
What is t sql in sql server?
What is difference between sql function and stored procedure?
How to get help at the sql prompt?
SELECT category, type, AVG(price) FROM products GROUP BY category, type ORDER BY 1, 2 If there are three distinct categories in the "products" table, and each one has five different types, how many rows are returned by the query above? 1. 1 row 2. 3 rows 3. 5 rows 4. 8 rows 5. 15 rows
How do I view stored procedures?
What is a full join?
-
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)
