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 are the properties and different types of sub-queries? : Sql dba

0 Answers  

---

What are the different dcl commands in sql?

0 Answers  

---

explain advantages of myisam over innodb? : Sql dba

0 Answers  

---

How to create an array in pl/sql?

0 Answers  

---

---

Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com

11 Answers  

---

What is the difference between truncate and drop statements?

0 Answers  

---

Can we use having without group by in sql?

0 Answers  

---

i have a table like this. cityno cityname mails 1 BANGALORE 8KM 2 HSR LAYOUT 20KM 3 MEJISTIC 30KM 4 JAYADEVA 55KM 5 ITPL 80KM 6 HEBBAL 115KM I HAVE DATA LIKE THIS I WANT O/P LIKE THIS DISTANCE NO.OFCITY 0-50KM 3 51-100KM 2 101-150KM 4 AND SO ON pls give me answer. i want urgent

6 Answers  

---

what are string data types? : Sql dba

0 Answers  

---

how to use in conditions? : Sql dba

0 Answers  

---

define sql update statement ? : Sql dba

0 Answers  

---