Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 12387 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 language is supported by sql server?
What is resource governor?
What is indexed view? How to create it?
what are the different ways to return the rowcount of a table?
What are the operating modes in which database mirroring runs?
what are the three command line utilities and what are their primary functions?
How is sql used in sql server?
How can I change procedure name in sql server?
Where sql server usernames and passwords are stored in a sql server?
What is a partition function in sql server?
What are different types of raid configurations? : SQL Server Architecture
Explain syntax for disabling triggers?
What are difference between Cluster index and Non-Cluster index?
What are the different types of Indexes available in SQL Server?
How to create user messages with print statements in ms sql server?
