over 4 years ago
In SQL if we dont have used primary keys then our id gets repeated accidentally or unintentionally.
In this case we need to find out how many records are same. We need to find out the same tuples or rows from a table.
For doing that we will perform a query to figure out the number of record repeated how many times by counting it
SELECT FirstName, LastName, MobileNo, COUNT(FirstName) as CNT
GROUP BY FirstName, LastName, MobileNo
HAVING COUNT(1) > 1
This will show how many times the records gets repeated
Starting with Chrome version 45, NPAPI is no longer supported for Google Chrome. For more information, see Chrome and NPAPI (blog.chromium.org).
Firefox and Microsoft Internet Explorer are recommended browsers for websites using java applets.
Chrome Version Support
Are you sure, you want to delete this comment?
Terms of Service
| © copyright 2020 FindNerd.com. All rights reserved.
Sign up using