What is record variable?

0 Answers  

---

What is the need of merge statement?

0 Answers  

---

what does myisamchk do? : Sql dba

0 Answers  

---

What is the purpose of design view?

0 Answers  

---

Hello All, Could any well write a query for the following scenario. Account(table name) No Name Amount 1 ABCD 2000.00 2 DEFG -2000.00 3 GHIJ 3000.50 4 JKLM 4000.00 5 MNOP 6000.00 O/p Should be in this format No Name Credit Debit 1 ABCD 2000.00 0 2 DEFG 0 -2000.00 3 GHIJ 3000.50 4 JKLM 0 -4000.00 5 MNOP 6000.00 o could any one give appropriate query for this Thnks in Advance

5 Answers   Target,

---

Can we create index on primary key?

0 Answers  

---

What is pl sql package?

0 Answers  

---

What is normalization and types of normalization?

22 Answers   Etisbew, F-TEC, Microsoft, TechProcess,

---

What is the use of procedures?

0 Answers  

---

How do I count duplicates in sql?

0 Answers  

---

What is the difference between partitioning and sharding?

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  

---