Table - Products has number of products as below Productid ProductName 1 iPhone 2 iPad 3 BlackBerry Table - SalesPersonProduct has the below records Salespersonid productid S1 1 S1 2 S1 3 S2 1 S3 2 Write a SQL query that returns the number of sales for each product

2 Answers  

---

Write a SQL Query to find first Week Day of month?

2 Answers  

---

What is ms sql server reporting services?

0 Answers  

---

What do you mean by a dependent functionality in a build?

0 Answers   HCL,

---

What are the parts of a function?

0 Answers  

---

what is maximum size of temp db?

4 Answers   iSoft,

---

what's the difference between delete table and truncate table commands? : Sql server database administration

0 Answers  

---

what is curser.

9 Answers  

---

What is the advantage of sql server?

0 Answers  

---

1. SELECT SUM(sal) as “Gross Salary” from EMPLOYEES; 2. SELECT MAX(sal) as “Highest Salary” from EMPLOYEES; ouput should be in table format

2 Answers  

---

to explain sql server 2000 architecture & authentication

1 Answers   HCL,

---

between cast and convert which function would you prefer and why?

0 Answers  

---