Write a query to delete duplicate records in SQL SERVER
- 36 Answers
- 67710 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / pavan kumar
Mr. Chandran, I tried your query but the system is throwing
error message as 'Incorrect syntax near the
keyword 'group''.
| Is This Answer Correct ? | 28 Yes | 14 No |
Post New Answer View All Answers
What is the difference between Clustered and Non-Clustered Index?
Do you know how to send email from database?
What command do we use to rename a db, a table and a column?
Explain how to integrate the ssrs reports in application?
Write an sql query to find first weekday of the month?
When to use Inner join & when to use subquery?
How exceptions can be handled in sql server programming?
What is self join in sql server joins?
Can We Use Data-grids For Our Report In Ssrs?
What is application role in sql server database security? : sql server security
what data regions are and what are the different data regions?
What are the restrictions that views have to follow?
What is a not null constraint?
This question asked during interview, 2) At the end of each month, a new table is created for each bank that contains monthly metrics consolidated at the account level. The table naming convention is bankX_YYYYMM where X represents the numeric designation of the bank and YYYYMM indicates the 4 digit year and 2 digit month. The tables contain the following fields: name data type description account text account number registered boolean indicates whether the account is registered num_trans integer number of transactions made during the time period spend numeric(9,2) total spend during the time period a) Write a SQL query that will display the total number of transactions and total spend for "Bank1" during the 4th quarter of 2009. b) Write a SQL query that will display the total number of transactions and total spend at "Bank1" and "Bank2", broken out by registered vs. non-registered accounts, during January 2010 not sure what is correct answer and how to solve?
1.what are diff types of joins , and explain diff between cross join and full outer join 2.diff types of views 3. Diff types of index 4. What is diff b/w stores procedure and function procedure 5.diff between double and int in SQL 6.diff between char and varchar in SQL. 7.Oracle or SQL whice you will preferred and why.
