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,

---

hw you create table in sql using existing table and variable should be in specific order given ex : in old table empid empname empsal empage empbirthdate empaddrs like is there in new table we need it as EX: exmpname empage empaddrs empid empbirthdate like we want hw we create this as a table not view or nt reporting

2 Answers  

---

Can you create a logon trigger in sql server 2005 express edition?

0 Answers  

---

explain databases and sql server databases architecture? : Sql server database administration

0 Answers  

---

What is sql server schema compare? How we can compare two database schemas?

0 Answers  

---

What is the openxml statement in sql server?

0 Answers  

---

What is checkpoint in sql server?

0 Answers  

---

What is catalog views?

0 Answers  

---

What is importing utility?

0 Answers  

---

can anybody tell us, how to select 2nd max salary from table. my id is ashish.akk@gmail.com

28 Answers   IBM, Symphony,

---

Is it possible to replicate data from sql server to oracle? : sql server replication

0 Answers  

---

How can I create a table from another table without copying any values from the old table?

3 Answers  

---