17. TCS SQL Interview Questions and Answers| Advance SQL Interview Questions| Pandey Guruji

----------------------------------------------------------------------------------------------------------------------------
Question: I have a table in production that has duplicate data. I can not delete existing rows because of business rules but somehow I have to prevent any further duplication of data in a table. How do achieve it?
-----------------------------------------------------------------------------------------------------------------
For any queries contact me on social media:
-------------------------------------------------------------------------------------------------------------------
--------------------------------------------------------------------------------------------------------------------
This Video contains In-depth coverage of the Following:
Query-based interview questions in SQL
Scenario-based interview questions and answers
SQL interview questions and answers
SQL practice exercises with solutions
SQL interview questions
SQL Server interview questions and answers for experienced
SQL interview questions and answers for experienced
Advanced SQL Interview Questions
SQL interview questions for 6 years of experience
SQL practice set
SQL server practice questions
SQL server practice exercises with solutions
SQL practice exercises with solutions
These video series will help to crack interviews and get jobs in SQL Developer, Database Developer, Data Engineer, Reporting Analyst, Data Analyst, Data Scientist, System Analyst, Power BI Developer, Tableau Developer, BI Developer, etc.

#SQL, #Interview, #PandeyGuruji
-------------------------------------------------------------------------------------------------------------------
Disclaimer - This video is just for educational purposes.
Copyright Disclaimer under Section 107 of the Copyright Act 1976, allowance for the "fair use".
All the images, music, and graphics used in this video belong to their respective owners and I or this channel do not claim any right over them.
Copyright Disclaimer under section 107 of the Copyright Act 1976, allowance is made for “fair use” for purposes such as criticism, comment, news reporting, teaching, scholarship, education, and research. Fair use is a use permitted by copyright statute that might otherwise be infringing

[BewithuNnk]

Hi Guru Ji, If not inserting data by Procedure how can we do this? I mean if data is entered by enduser through application is it helpful? Pls clarify my doubt?

[nupur]

In the stored procedure, only employee id should be checked for duplicates, as two persons can have same names or each department will have more than 1 person means these two columns can contain duplicate data.

[sampurnabhattacharjee]

COuld we use alter table and modify the column with primary key constraint?
ALTER TABLE EMPLOYEES
MODIFY CONSTAINT emp_pk PRIMARY KEY(empid, empname, depid);

[ahmermohiuddinsiddique]

Pandey Ji, Yesterday I paid 226.03 Rupees 199 + 27.03 convenience fee and I suppose to get the study material downloaded. but the file didn't download. Please share the study material. waiting for your reply.