i have table students with fields classname,studname select * from students classname studname 1 xxxxx 1 yyyy 1 zzzz 2 qqqq 2 tttt 3 dsds 3 www i want the output should be No of students in class 1 : 3 No of students in class 2 : 2 No of students in class 3 : 2

5 Answers   HCL, ZX,

---

Define full outer join in sql server joins?

0 Answers  

---

What is the need for indexing?

0 Answers  

---

Advantages and disadvantages of stored procedures.

2 Answers   HCL,

---

How can I enforce to use particular index?

1 Answers   Symphony,

---

What is the difference between a view and a stored procedure?

0 Answers  

---

what are the Prerequisites for Replication?

1 Answers   IBM,

---

how to count datewise data in sqlserver

4 Answers   CarrizalSoft Technologies, IndusInd Bank,

---

How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

0 Answers   ABC,

---

What is the command used to recompile the stored procedure at run time?

0 Answers  

---

How to find out name of all employees who has salary less than 200 Rs.?

8 Answers  

---

What is sql server replication? : sql server replication

0 Answers  

---