table name: prod there are three fields in the table that are 1.proddate 2.prodQty 3.model Day wise prodQty is stored in the table prod write a query to display total prodqty in the year 2004 april.

2 Answers   Maruti Suzuki,

---

What are the built in functions of sql?

0 Answers  

---

Can we have two clustered index on a table?

0 Answers  

---

what is rollback? : Sql dba

0 Answers  

---

How do I count duplicates in sql?

0 Answers  

---

---

What's the difference between a primary key and a clustered index?

0 Answers  

---

tell us something about heap tables. : Sql dba

0 Answers  

---

What is foreign key sql?

0 Answers  

---

how do you restrict number of rows for a particular value in a column.For example:there is a table called fruits,having apples,bananas ,papayas.I dont want to have more than 100 apples in that table ,so how can u restrict number of rows for apple to hundred?

6 Answers  

---

From an Employee table, how will you display the record which has a maximum salary?

29 Answers   Cap Gemini, Exilant, Synechron,

---

Explain what is a database?

0 Answers  

---

How many types of indexes are there in sql?

0 Answers  

---