A table contains list of customers and his city with other details. Each customer has a unique number and the table consists millions of data. Query is: I want to retrieve 10 customers from each city, no script, only from single query?

8 Answers   Infosys,

---

What is cursor in ms sql server?

0 Answers  

---

Does order by actually change the order of the data in the tables or does it just change the output?

0 Answers  

---

What is query processing?

0 Answers  

---

Explain collation?

0 Answers  

---

---

How network traffic be reduced by using the stored procedure?

0 Answers   Accenture,

---

What do you understand by triggers?

0 Answers  

---

What is temporary stored procedure?

0 Answers  

---

What are the different normalization forms?

0 Answers  

---

What is a filestream?

0 Answers  

---

How get current date in SQL server 2000

4 Answers   Cap Gemini, Polaris,

---

How can you control the amount of free space in your index pages?

0 Answers  

---