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 set nocount on?
What are security principals used in sql server 2005?
What is sub-query in sql server?
What is Command line parameters in PLSQL.?
How many servers can we create in a single subscription?
What happens when converting big values to integers?
How can I check that whether automatic statistic update is enabled or not?
What are sp_configure commands and set commands?
What is a partitioned view?
Can a table be moved to different filegroup?
What languages bi uses to achieve the goal?
How to skip remaining statements in a loop block using continue statements?
Can you move the resources after pausing the node? : sql server database administration
When would you use sql joins?
What are user defined functions in ms sql server?