Why self join is used in sql?

0 Answers  

---

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  

---

Can cursors be part of a trigger body?

0 Answers  

---

Explain commit, rollback and savepoint.

0 Answers  

---

what is the difference between pragma exception_init and raise_application_error

1 Answers   Aetins, State Street,

---

What does select count (*) mean in sql?

0 Answers  

---

While inserting/updating million of records into a database table, how do I came to know how many records has been inserted or updated successfully so far?

2 Answers   HSBC,

---

Write a sql query to get the third highest salary of an employee from employee_table?

0 Answers  

---

What are the possible values that can be stored in a boolean data field?

0 Answers  

---

In table a 1lakh data is present,in table b 20 thousand data is present, to get unique data from table a and b which join to be considered. whether right outer join or left inner join. 

2 Answers   GE,

---

When to use inner join and left join?

0 Answers  

---

Why use stored procedures?

0 Answers  

---