table structure: ---------------- col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10 01-mar-2012 11:12:46 01-mar-2012 11:11:23 Write a query to display the result as shown below: col1 col2 ----- ----- 01-mar-2012 11:12:46 01-mar-2012 11:12:10

2 Answers  

---

How many commands are in sql?

0 Answers  

---

What are nested triggers ?

6 Answers   Amazon, Appeal Soft, IBM, Infosys, TCS,

---

how can we submit a form without a submit button? : Sql dba

0 Answers  

---

Is natural join and inner join same?

0 Answers  

---

---

What is package in pl sql with an examples?

0 Answers  

---

What is the main difference between sql and pl/sql?

0 Answers  

---

How do you modify a trigger?

0 Answers  

---

What is the difference between unique and primary key constraints?

0 Answers  

---

what is query cache in mysql? : Sql dba

0 Answers  

---

What is the main difference between a UNION statement and a UNION ALL statement? 1. A UNION statement eliminates duplicate rows; a UNION ALL statement includes duplicate rows. 2. A UNION statement can be used to combine any number of queries; a UNION ALL statement can be used to combine a maximum of two queries. 3. A UNION statement can only combine queries that have parallel fields in the SELECT list; a UNION ALL statement can combine queries with differing SELECT list structures. 4. A UNION statement cannot be used with aggregate functions; a UNION ALL statement can be used with aggregate functions. 5. There is no difference between the two statements; they are interchangeable.

2 Answers   Saman Bank, Sonata,

---

What is pl sql architecture?

0 Answers  

---