Answer / subbareddy.l

Hi,

This query will give us number of sales product wise


select SPP.Productid,COUNT(SPP.Productid)CC from
SalesPersonProduct SPP inner join products P
ON SPP.Productid=P.Productid
group by SPP.Productid

Thanks,
subbareddy.l

Answer / madhu sudhan g

Hiii

try this query you will get the answer

select count(1) as SalesCount,P.Product from Products P
INNER JOIN SalesPersonProduct S ON S.Id=p.Id group by P.Product

what is sql injection in sql server?

2 Answers   TATA,

---

could u plz explain about joins and views?

2 Answers  

---

WHY CAN WE CREATE ONLY ONE CLUSTERED INDEX ON A TABLE IN SQL SERVER?

8 Answers  

---

what is blocking? : Sql server database administration

0 Answers  

---

what is the query and condition to delete datas in sql server.

2 Answers  

---

---

what is the maximum size of a row? : Sql server database administration

0 Answers  

---

What are the acid properties?

0 Answers  

---

What are the differences between char and nchar in ms sql server?

0 Answers  

---

Which is better in performance - CONSTRAINT or TRIGGER over a column which restricts say an input of particular value in a column of a table?

3 Answers   Accenture,

---

Create Index myIndex On myTable(myColumn) What type of Index will get created after executing the above statement

3 Answers  

---

what are the steps you will take to improve performance of a poor performing query? : Sql server database administration

0 Answers  

---

What is sql server locking?

0 Answers  

---