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....

What are the requirements for sql server 2016?

0 Answers  

---

Does a full backup include transaction log?

0 Answers  

---

What is user-defined scalar function?

0 Answers  

---

How retrieve field names from the table in SQL through JAVA code?

0 Answers  

---

How to use transact-sql statements to access the database engine?

0 Answers  

---

please give me query code of unique fuction select UNIQUE (name) from emp_info Incorrect syntax near the keyword 'UNIQUE'.

1 Answers   TCS,

---

How to handle errors in Stored Procedures. I want to display a message to the user in the .aspx page that is calling a stored procedure in it's code behind. please help me.

2 Answers   247Customer,

---

What is the recovery model? List the types of recovery model available in sql server?

0 Answers  

---

Say if we have a table that contains only a single column , say OrderID, which has IDENTITY attribute defined on it. So how can we insert data in this table. I am reframing my question, that how can we make the table to increment the column "OrderID" value several times???

3 Answers  

---

What is PROJECTION Operation?

0 Answers   Infosys,

---

What is sparse columns of sql server 2008?

0 Answers  

---

what are the main differences between ms access and sqlserver

1 Answers   C DAC, CDAC,

---