Answer / mythili

select BillDate, count(*) from AdminSalesDetailsItems group by BillDate

Answer / amit bhardwaj

SELECT COUNT(colmnName) FROM Tablename GROUP BY Columnname

Answer / ambi

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varchar(50),BillDate,101)

select BillDate, count(*) [Total] from
AdminSalesDetailsItems group
by convert(varcharBillDate,101)

Answer / vidit tyagi

select BillDate, count(*) from AdminSalesDetailsItems group
by convert(BillDate,varchar,101)

Can coalesce return null?

0 Answers  

---

How to receive returning result from a query?

0 Answers  

---

Explain “row_number()” in sql server with an example?

0 Answers  

---

Explain about extended stored procedure?

0 Answers  

---

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

0 Answers  

---

---

What are the security related catalog views? : sql server security

0 Answers  

---

Where is SQL Srever (In sQL server 2005/2008 where is SQL Server Located).

2 Answers   TCS,

---

What is an extended Stored Procedure?

1 Answers  

---

What are the different SQL Server Versions you have worked on?

0 Answers  

---

what's the difference between SQL & MY-SQl...? And what we learn from these ....?

2 Answers   Broadridge,

---

how to find nth highest salary

103 Answers   Cognizant, IBM, NexGen, Oracle,

---

How to create a view with data from multiple tables?

0 Answers  

---