Answer / sd

While using aggregate functions.

Answer / vampire007

We use GroupBy clause to analyze data in table,by means of
various sql server aggregate functions like SUM(), AVERAGE
() etc., according to some domain.

For eg., If we want to know the sales done by a every
employee, then we would use somewhat this kind of query:

/**
select employeeid, count(*)
from orders
groupby employeeid
order by employeeid
**/

Answer / satyanarayana

In order to provide a condition to the select statement
either by group by column or aggregate function

Answer / ricky

while we are using a aggregate function we use the group by
clause....

Explain what is the use of custom fields in report?

0 Answers  

---

What are the types of constraints?

1 Answers  

---

If any possiable to use 2 primary key in single table? How many primary key & foreign key used in each table(min & max)?

3 Answers  

---

What are indexes in ms sql server?

0 Answers  

---

How to add additional conditions in SQL?

0 Answers   Amdocs,

---

How to add more data to the testing table in ms sql server?

0 Answers  

---

Can a cursor be updated? If yes, how you can protect which columns are updated?

0 Answers  

---

Write the SQL query to drop, truncate and delete table.

0 Answers   HPCL, Hughes Systique Corporation, Ittiam Systems,

---

which table keeps the locking information? : Sql server administration

0 Answers  

---

What is the SQL?????????????????????????????

5 Answers   CMS,

---

What is the Query of getting last 10 transaction Reports (like insert, update, Delete Data from Tabele) ?

4 Answers   Wipro,

---

Explain index in sql server?

0 Answers  

---