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 |
Post New Answer View All Answers
what authentication modes does sql server support? : Sql server database administration
What is side by side migration in sql server?
How to check parameter value in stored procedure sql server?
Can we hide the definition of a stored procedure from a use?
Can you explain how long are locks retained within the repeatable_read and serializable isolation levels, during a read operation with row-level locking?
What is extent? Types of extents?
What is the default order of an order by clause?
what happens on checkpoint? : Sql server database administration
Where sql server user names and passwords are stored in sql server? : sql server database administration
How to replace given values with null using nullif()?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
How to enter date and time literals in ms sql server?
Explain Normalization and DE normalization
Do you know what are the reporting services components?
How is sql server used?