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  

---

What does dml mean?

0 Answers  

---

How long will it take to learn pl sql?

0 Answers  

---

What is the purpose of primary key?

0 Answers  

---

What is secondary key?

0 Answers  

---

---

How can u find column name from a table which have max value in a row.( not max value)

5 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

Why do we use sqlite?

0 Answers  

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

write a query to delete similar records in same table

13 Answers   TCS,

---

What is the purpose of my sql?

0 Answers  

---

Does sql use python?

0 Answers  

---