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?
Answer Posted / sonal parekh
select Top 10 CustomerName, city from customer
|Is This Answer Correct ?||5 Yes||31 No|
What is transaction server auto commit?
Explain try...catch with sql server?
What is the use of @@spid?
What are the restraints imposed on the table design by a merge replication?
What is sql language?
What are the differences between char and nchar in ms sql server?
What is the difference between count and distinct count?
What is an identity column in insert statements?
What happens if you delete a table that is used by a view?
How to create a dynamic cursor with the dynamic option?
what is the system function to get the current user's user id? : Sql server database administration
What are various ways to enhance the ssrs report?
What is logshipping and its purpose?
what are the new features in SSRS?
application server is slow what may be the problem