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
- 10755 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
What is sql service broker?
What is log cache in sql server?
What is the Disadvantage of indexed sequential file.
What are sql dirty pages?
Where can you add custom error messages to sql server?
Do you know what are the restrictions applicable while creating views? : SQL Server Architecture
How to connect of datebase with sql express.?
What language is sql server written in?
How to provide default values to stored procedure parameters?
what's the maximum size of a row? : Sql server database administration
explain what is raid and what are different types of raid configurations? : Sql server database administration
We are updating a field in sql and alter the row also.after giving the commit command the system is crashed.what will happen to the commands given,whether it will update and alter the table or not?
How can a user-defined datatype be created?
What are the dis_advantages of stored procedures, triggers, indexes?
Delete duplicate rows without using rowid.
