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 set nocount on?

13


What are security principals used in sql server 2005?

11


What is sub-query in sql server?

2


What is Command line parameters in PLSQL.?

24


How many servers can we create in a single subscription?

17






What happens when converting big values to integers?

7


How can I check that whether automatic statistic update is enabled or not?

3


What are sp_configure commands and set commands?

3


What is a partitioned view?

3


Can a table be moved to different filegroup?

1


What languages bi uses to achieve the goal?

5


How to skip remaining statements in a loop block using continue statements?

11


Can you move the resources after pausing the node? : sql server database administration

13


When would you use sql joins?

4


What are user defined functions in ms sql server?

9