Sunday, April 23, 2023

How to remove dublicate record in a table

 DELETE P1 FROM ProductId AS P1

INNER JOIN PRODUCTID AS P2 ON

P1.ProductId>P2.ProductId AND P1.PName=P2.PName


-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

How to use SQL pagination using LIMIT and OFFSET

  How to extract just a portion of a larger result set from a SQL SELECT. LIMIT n is an alternative syntax to the FETCH FIRST n ROWS ONLY. T...

  • Difference between Unique Key and Primary Key.
    Difference Between Primary key & Foreign key Primary Key Foreign Key Helps you to uniquely identify a record in the table. It is...
  • What is Trigger and Why we use It.
    Ans: A trigger is a special kind of Stored Procedure or stored program that is automatically fired or executed when some event (insert, d...
  • TUPLE
    A tuple is a data structure that contains a sequence of elements of different data types.  It can be used where you want to have a data s...