Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12751 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / sonal parekh
select Top 10 CustomerName, city from customer
| Is This Answer Correct ? | 5 Yes | 31 No |
Post New Answer View All Answers
What is the command used to recompile the stored procedure at run time?
What is function of ROLLUP ?
What is use of attributehierarchyenabled? : sql server analysis services, ssas
Explain what is raid and what are different types of raid levels?
What are recommended options to be used while using db mirroring? : sql server database administration
How can you find out which stored procedures are recompiling?
Does sql server use t sql?
Does the order of columns in update statements matter?
Can we perform backup restore operation on tempdb? : sql server database administration
Tell me what is the stuff and how does it differ from the replace function?
How do we know if any query is retrieving a large amount of data or very little data?
Explain magic tables in sql server?
In which tcp/ip port does sql server run? Can it be changed?
What will be the maximum number of indexes per table?
What is an identity column in insert statements?
