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 is filestream?
What is sql server database?
What is sql server agent and what are the two modes of authentication in sql server?
What is table value parameters (tvp)?
What do you understand by recursive stored procedure?
How do I create a trace in sql server?
What is user-defined function? Explain its types i.e. Scalar and inline table value user-defined function?
What happens to a trigger with multiple affected rows?
What is dbcc updateusage?
what's the difference between a primary key and a unique key? : Sql server database administration
What are partitioned views?
How do you debug a procedure in sql server?
What are the different types of columns types constraints in the sql server?
Tell me what is difference between clustered and non clustered index?
What is the difference between ddl,dml and dcl commands?