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)

What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

---

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

---

What do you understand by user-defined function in the sql server and explain the steps to create and execute a user-defined function in the sql server?

0 Answers  

---

write a query for list of owner who are having multiple bikes in below table 1 shanker pulsar 2 shanker Honda 3 shanker car 4 Balu pulsar 5 Balu Honda 6 Balu car 7 Shyam pulsar 8 Jaya Honda 9 Deepa car 10 vasu car

12 Answers   Cognizant, TCS,

---

What are the steps to process a single select statement?

0 Answers  

---

what is package configuration variable?How to change file name in folder dynamically?Plz help me

1 Answers  

---

PC(code, model, speed, ram, hd, cd, price) Find the hard drive sizes that are equal among two or more PCs.

6 Answers   APX,

---

How to create a view on an existing table in ms sql server?

0 Answers  

---

How to Insert multiple rows with a single insert statement?

0 Answers  

---

What is rolap and its advantage? : sql server analysis services, ssas

0 Answers  

---

explain the type of contraints

3 Answers  

---

What is the diff between Dynamic queries and static queries

1 Answers   CGG, ICS Integrated Computer Solutions,

---