Find Duplicate Data Query Syntex Given Below - B M SOLUTION
  • / / Find Duplicate Data Query Syntex Given Below

    Find Duplicate Data Query Syntex Given Below

    08:55 0


    SELECT

     RollNo, StuName,MobileNo, COUNT(*)

    FROM

        StudentReg1

    GROUP BY

       RollNo, StuName,MobileNo

    HAVING 

        COUNT(*) > 1

    • You might also like

    No comments :

    Post a Comment

Subscribe to: Post Comments ( Atom )