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 deploy, process and build? : sql server analysis services, ssas

0 Answers  

---

Explain datetime2 data type in sal server 2008?

0 Answers  

---

List some advantages and disadvantages of stored procedure?

0 Answers  

---

when inserting to a table how many rows will be effected using triggers

2 Answers  

---

How to delete multiple rows with one delete statement in ms sql server?

0 Answers  

---

What is a benefit of using an after insert trigger over using a before insert trigger?

0 Answers  

---

How can count the string ? for ex: If i have string like 'bhaskar' then i need like b:1 h:1 a:2 s:1 k:1 r:1 please give any idea on that

9 Answers   TCS,

---

How to count the number of duplicate items in a table?

3 Answers  

---

What are the database roles? : sql server security

0 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

Please tell me some knowledge about Clustering and how to add clustering?

1 Answers  

---

Can a rule be bound to any column of any data type?

0 Answers  

---