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






Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is transaction server auto commit?

27


Explain try...catch with sql server?

42


What is the use of @@spid?

39


What are the restraints imposed on the table design by a merge replication?

40


What is sql language?

42






What are the differences between char and nchar in ms sql server?

42


What is the difference between count and distinct count?

13


What is an identity column in insert statements?

40


What happens if you delete a table that is used by a view?

45


How to create a dynamic cursor with the dynamic option?

48


what is the system function to get the current user's user id? : Sql server database administration

31


What are various ways to enhance the ssrs report?

41


What is logshipping and its purpose?

43


what are the new features in SSRS?

3


application server is slow what may be the problem

1253