select * from emp where sal in(select max(sal) from emp) here there is any limit for in operator how many values accpect ?

2 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  

---

What are the benefits of stored procedures?

0 Answers  

---

what is explain plan?

4 Answers  

---

i have a table like this. i want to output like this c1 c2 c1 c2 1 10 1 10 2 20 2 30 3 30 3 60 4 40 4 100 5 5 5 105 c1 and c2 are columns in a table .i want output like this c2 values are 10,10+20,10+20+30,10+20+30+40.10+20+30+40+5. write a sql query.pls help this i want urgent.

2 Answers   IBM, Loginworks, OFSS,

---

---

Advantages and disadvantages of stored procedure?

0 Answers  

---

If you have to declare procedure1,procedure2 in package specification and if you have to declare procedure1,procedure2 and procedure3 in package body? is it compilation or not and execute or not? what type of error is given please

1 Answers  

---

What is the best free sql database?

0 Answers  

---

What do you understand by exception handling in pl/sql?

0 Answers  

---

Why cross join is used?

0 Answers  

---

what is the difference between a web-garden and a web-farm? : Sql dba

0 Answers  

---

What are all the different normalizations?

0 Answers  

---