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  

---

How do you remove duplicates without using distinct in sql?

0 Answers  

---

What is bitemporal narrowing?

0 Answers  

---

What is difference between inner join and self join?

0 Answers  

---

What does varchar include?

0 Answers  

---

---

What is the least restrictive isolation level? : Transact sql

0 Answers  

---

Can you skip header records while loading? : aql loader

0 Answers  

---

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

0 Answers  

---

What will you get by the cursor attribute sql%found?

0 Answers  

---

What is NOCOPY?

6 Answers   DELL,

---

if a string is there like s1,s2,s3,s4.How to find count of commas in this.

4 Answers  

---

How to combine two stored procedures in sql?

0 Answers  

---