Write a query to display the duplicate records without using group by.
AnswerBot
2y
Query to display duplicate records without using group by
Use self-join to compare records
Select records where the values match but the primary key is different
Example: SELECT a.* FROM table a, table b...read more
Help your peers!
Add answer anonymously...
Accenture Business Intelligence Consultant interview questions & answers
A Business Intelligence Consultant was asked Q. How will you pass a database connection string at runtime?
A Business Intelligence Consultant was asked Q. What is the use of the ‘for XML’ command?
A Business Intelligence Consultant was asked Q. Write a query to display the duplicate records without using group by.
Popular interview questions of Business Intelligence Consultant
A Business Intelligence Consultant was asked Q1. How will you pass a database connection string at runtime?
A Business Intelligence Consultant was asked Q2. What is the use of the ‘for XML’ command?
A Business Intelligence Consultant was asked Q3. What is the difference between STUFF() and SUBSTRING()?
>
Accenture Business Intelligence Consultant Interview Questions
Stay ahead in your career. Get AmbitionBox app
Trusted by over 1.5 Crore job seekers to find their right fit company
80 L+
Reviews
10L+
Interviews
4 Cr+
Salaries
1.5 Cr+
Users
Contribute to help millions
AmbitionBox Awards
Get AmbitionBox app
Made with ❤️ in India. Trademarks belong to their respective owners. All rights reserved © 2025 Info Edge (India) Ltd.
Follow Us
