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
- 12989 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
Explain about sql server login?
What happens if you add a new index to large table?
How to manipulate data from one table to another table ?
How to rename an existing column with the "sp_rename" stored procedure in ms sql server?
What is the chart in report?
Is the log file is a part of file group?
How to call stored procedure using http soap?
How do I install sql server?
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What does top operator do?
what's the difference between delete table and truncate table commands? : Sql server database administration
What are the pros and cons of putting a scalar function in a queries select list or in the where clause?
Name the different type of indexes in sql?
Why is normalisation important?
How to get a list of columns in a view using "sys.columns" in ms sql server?
