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
- 10119 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
You want to implement the many-to-many relationship while designing tables. How would you do it?
Can you give me some DBCC command options?(Database consistency check) - DBCC CHECKDB - Ensures that tables in the db and the indexes are correctly linked.and DBCC CHECKALLOC - To check that all pages in a db are correctly allocated. DBCC SQLPERF - It gives report on current usage of transaction log in percentage. DBCC CHECKFILEGROUP - Checks all tables file group for any damage.
What does COMMIT command do?
You want your report to display a hyperlink that will take users to your intranet. How do you configure such a hyperlink?
Can foreign key be duplicate?
What is the standby server?
How do you create type- insensitive operator?
how to define testing of network layers? : Sql server database administration
What do you understand by the data quality services in sql server?
Explain the rules for designing files and file groups in sql server?
What are the kinds of subquery?
Tell me extended events in sql server 2008?
If a table does not have a unique index, can a cursor be opened on it?
How do I find the transaction log size in sql server?
What are the advantages of user-defined functions over stored procedures in sql server?
