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
- 12965 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
What is open database communication (odbc)?
What are different types of database indexes?
Do you know what is a trace frag? Where do we use it?
Can you change the data type of a column in a table after the table has been created? If so, which command would you use?
When does the auto update index statistics feature in sql server turn itself on?q) what specific conditions database should meet, before you can bulk copy data into it using bcp?
How to Improve the performencs of SQL Server 2005 exclude stored Procedure and Indexes?
Write a code to select distinct records without using the DISTINCT keyword.
What is temporary table in sql server? Why we use temp table?
List the different types of collation sensitivities in sql server?
What is the purpose of floor function?
How do you manipulate data?
You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?
How will you hide an attribute? : sql server analysis services, ssas
What happens if the update subquery returns multiple rows in ms sql server?
What happens if you delete a table that is used by a view?
