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,

---

Is join and inner join the same?

0 Answers  

---

what is top in tsql? : Transact sql

0 Answers  

---

what are the different tables present in mysql? : Sql dba

0 Answers  

---

What is the difference between partitioning and sharding?

0 Answers  

---

what is the difference between varray and table data type..please expalain with some examples... under what situation you will go for varray..instead of index by table...

1 Answers   HCL, Satyam,

---

How to make a copy values from one column to another in sql?

0 Answers  

---

I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,

---

If a cursor is open, how can we find in a pl/sql block?

0 Answers  

---

SELECT ROUND(TRUNC(MOD(1600,10),-1),2) FROM dual;

10 Answers  

---

How do I start sql profiler?

0 Answers  

---

What is sql and explain its components?

0 Answers  

---