How can we avoid duplicating records in a query?

0 Answers  

---

what is the difference between union and union all? : Sql dba

0 Answers  

---

What is lookup table in sql?

0 Answers  

---

Display the total debit counts, total credit counts, sum of total debits, sum of total credits from an employee's transaction table (a single table) containing the following columns. Transaction_number Transaction_amount Transaction_date Transaction_type --> tells if the amount is a credit or a debit. As the query alone is important, the table is left with specifying just the field's name. Pls help me with this query.

3 Answers   iNautix, Oracle,

---

What does inner join mean?

0 Answers  

---

What are literals in sql server?

0 Answers  

---

What is implicit cursor in pl sql?

0 Answers  

---

what is the order of pre-defined exceptions.

6 Answers   TCS,

---

what is the difference between binary_integer and pls_integer

2 Answers   TCS,

---

If a procedure within a package is invalidated whether the entire package will be invalid and has to be recompiled again?

2 Answers   IBM, TCS,

---

how is myisam table stored? : Sql dba

0 Answers  

---

Mention what are the benefits of pl/sql packages?

0 Answers  

---