Asked in Cognizant
Write a SQL query to delete duplicate records from a table.
AnswerBot
1y
SQL query to delete duplicate records from a table.
Use the DELETE statement with a subquery to identify and delete duplicate records.
The subquery should select the duplicate records based on the crite...read more
Sanjeevi Poojitha
2y
Select Distinct * from table;
Shilpa Kumbar
2y
SELECT DISTINCT * FROM EMP;
Anonymous
2y
SELECT DISTINCT * FROM EMP;
Anonymous
2y
select DISTINCT * FROM EMP;
Add answer anonymously...
Top Plsql Developer Interview Questions Asked at Cognizant
Q. What is the difference between RDBMS and DBMS?
Q. What is the difference between DELETE and TRUNCATE statements?
Q. Write a SQL query to find the nth highest salary.
Interview Questions Asked to Plsql Developer at Other Companies
Top Skill-Based Questions for Cognizant Plsql Developer
SQL Interview Questions and Answers
250 Questions
Triggers Interview Questions and Answers
50 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
