Find Duplicate Records in sql or Show Duplicate Record at once

  • Use Distinct Query 

    select distinct username,rollno,address from abc

    if there are same records in database distinct query shows it at once


    This will also find all duplicate records from table



















    SELECT orderid, COUNT(*) TotalCount FROM masterorder GROUP BY orderid HAVING COUNT(*) >
    1










Howdy, Stranger!

It looks like you're new here. If you want to get involved, or you want to Ask a new Question, Please Login or Create a new Account by Clicking below

Login with Facebook

Popular Posts of the Week

    Optimum Creative