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,

---

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

---

Can we have more than one NULL in a column having unique constraint?

12 Answers   247Customer,

---

If there is failure during updation of certain rows, what will be the state?

2 Answers  

---

How to create view in stored procedure sql server?

0 Answers  

---

What is model database in sql server?

0 Answers  

---

what are file groups?

3 Answers   Evalueserve,

---

what is an sql server?

1 Answers  

---

In which year relase the 7.0& 2000 & 2005?

1 Answers  

---

Hello all, I have data like :- year amt 2004 10 2005 20 2006 30 Now i want output as:- 2004 2005 2006 10 30 60 but i have to use here group by on year.So, i need a single query within that i can find.

3 Answers  

---

What command must you use to include the not null constraint after a table has already been created?

0 Answers  

---

How do I port a number to sql server?

0 Answers  

---