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,

---

What is page in sql server?

0 Answers  

---

List some of the rules that apply to creating and using a ‘view’

0 Answers  

---

how to find out the repeated value from table using groupby function?

4 Answers  

---

You want to be sure that queries in a database always execute at the maximum possible speed. To achieve this goal you have created various indexes on tables which other statement will keep the database in good condition?

0 Answers  

---

Explain log shipping?

0 Answers  

---

Wht is the difference between stored procedure and trigger

6 Answers   HCL, TCS,

---

How to execute a sql statement using odbc_exec()?

0 Answers  

---

What is Service Broker in sql server 2012?

0 Answers   UGC Corporation,

---

Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

---

Differentiate between delete and truncate.

0 Answers  

---

What are basics of policy management?

0 Answers  

---