consider a table which contain 4 columns,ename,eno,sal and deptno, from this table i want to know ename who having maximum salary in deptno 10 and 20.

24 Answers   Mind Tree,

---

I have one table and column is c1 pk, c2 not null,c3 not null and 200 row in it and i add c4 column and value, how can is possible

9 Answers  

---

Can we use out parameter in function?

4 Answers   Infosys,

---

What is difference between a PROCEDURE & FUNCTION ?

6 Answers   Satyam,

---

how to use myisamchk to check or repair myisam tables? : Sql dba

0 Answers  

---

---

What is sql resultset?

0 Answers  

---

My select statement is not working as expected, So, to overcome from such issues what are the steps needed to be taken care?

2 Answers   CG,

---

explain commit and rollback in mysql : sql dba

0 Answers  

---

What is cross join sql?

0 Answers  

---

What is Temp Table and type of temp table?

1 Answers   HP, SLK,

---

how to get @@error and @@rowcount at the same time? : Sql dba

0 Answers  

---

Can two tables have same primary key?

0 Answers  

---