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  

---

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 Suneel Reddy

6 Answers   Target,

---

How long will it take to learn pl sql?

0 Answers  

---

how can create data base link for tow servers (scott schema) give examples plz

2 Answers  

---

How do I clear the screen in sql plus?

0 Answers  

---

---

i have one table with accounts and amounts as colums.accounts with columns c and d. and amounts with values 1000,2000,3000 for c and 4000,5000,8000 for d.i need to find the sum of these accounts c and d individually and find the differences between their sum using one select statement.

11 Answers   Ebix, Hewitt,

---

What is coalesce in sql?

0 Answers  

---

how to include comments in sql statements? : Sql dba

0 Answers  

---

Name the different types of indexes in sql and define them.

0 Answers  

---

What are the subsets of sql?

0 Answers  

---

how to connect oracle in unix prompt?

4 Answers   Polaris,

---

how to find 5th row ?

10 Answers  

---