trans_id trans_date trans_amt debit_credit_indicator 001 01-JAN-13 1099 cr 001 12-JAN-13 500 db 002 24-FEB-13 400 db 002 23-MAR-13 345 cr 001 18-APR-13 800 cr 002 15-MAR-13 600 db 001 12-FEB-13 200 cr i want like this output trans_id trans_date trans_amt debit_credit_indicator 001 JAN 1599 cr no.of trans 2 i want trans_id and trans_date like 'JAN' or 'FEB' etc, trans_amt i want all credit amount - debit amount per each trans_id. and debit_credit_indicator and no.of transactions in a month.

1 Answers   Oracle,

---

List the various privileges that a user can grant to another user?

0 Answers  

---

What is the use of sql trace?

0 Answers  

---

What is the difference between python and sql?

0 Answers  

---

what is a composite primary key ? : Sql dba

0 Answers  

---

---

What does trigger mean in slang?

0 Answers  

---

What problem one might face while writing log information to a data-base table in pl/sql?

0 Answers  

---

what is cursor procedure

1 Answers   iGate,

---

What is left join in sql?

0 Answers  

---

Write a query to find the names of users that begin with "um" in sql?

0 Answers  

---

Enlist some predefined exceptions?

0 Answers  

---

source destination distance chennai bangalore 500 bangalore chennai 500 hyd delhi 1000 delhi hyd 1000 bangalore hyd 800 Here chennai to bangalore and bangalore to chennai is same distance. and hyd and delhi also same criteria. Based on the distance i want to display only one row using sql query?

4 Answers   JPMorgan Chase,

---