Why we use joins in sql?

0 Answers  

---

what is a view? : Sql dba

0 Answers  

---

write a query to delete similar records in different tables with same structure

4 Answers  

---

What are the differences between Database Trigger and Integrity constraints ?

4 Answers  

---

2. Select A.A from ( select 1 as from dual Union select 1 as from dual)A Full outer join ( select 1 B from dual Union select 2 B from dual)B On A.A=B.B

2 Answers   Fintellix,

---

What jobs use sql?

0 Answers  

---

How can I change database name in sql?

0 Answers  

---

What is having clause in sql?

0 Answers  

---

How many clustered indexes can be created on a table?

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,

---

how to see the oracle 9i/10g table in pc? or In my pc where the table is saved and how to see?

1 Answers  

---

i have a table t1 a math 20 b phy 30 cchemisty 10 a math 40 b phy 23 c che 21 a math15 bphy 33 c che 56 write a quire to find out the max markr of each subject

8 Answers  

---