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
- 11177 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
Which are ddl commands?
How to backup SQL Server Reporting Services ?
Can we delete data from a view?
How can we get count of the number of records in a table?
Why is the need for data conversion transformations?
What are recommended options to be used while using db mirroring? : sql server database administration
How to fine-tune reports?
Where can you add custom error messages to sql server?
How display code or Text of Stored Procedure using Sql query in Sql Server ?
While you are inserting values into a table with the insert into .. Values option, does the order of the columns in the insert statement have to be the same as the order of the columns in the table?
How to stop a loop early with break statements in ms sql server?
What is a database in ms sql server?
How do I start and stop sql server?
Explain the dbcc pintable command when would you use it?
Explain Capacity planning to create a database? and how to monitor it?
