How do I detect a duplicate row in database table with sql?

 i want to detect the duplicate columns of database table. the sql is given below: 

select column_name, count( column_name) as number_of_occurrences from table_name Group_by column_name Having(count(column_name)>1) limit 0,100


SELECT MemberId, COUNT( MemberId ) AS NumOccurrences
FROM members
GROUP BY MemberId
HAVING (
COUNT( MemberId ) >1
)
LIMIT 0 , 238

Comments

Post a Comment

Popular posts from this blog

PHP7.3 installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                        No need any kind of introduction about php. php7.3 version has been released on 6th December  2018. This is the latest version of php. We will install php7.3 on our ec2 instance whose os is ubuntu 18.04. Requirements: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, if can't access please visit  blogspot  or  medium 4. nginx installation, if not installed please visit  blogspot  or  medium Step1: open your terminal and run the command: $ sudo apt update $ sudo apt upgrade Step2: Installation python software properties, software properties common and adding ondrej ppa with required packages. while installing software properties press 'ok' two times and while installing ondrej then click on enter button $ sudo apt install software-properties-common $ sudo apt-add-repository ppa:ondrej/php $ sudo apt update Step3...
Read more

composer installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                        Composer is not a package manager like yum/apt, it is a tool for dependency management in php. It allows to declare the libraries that your project depends on and it will manage 'install/update' the libraries for your project. Now you are thinking that it's not dealing with packages? yes it deals with 'packages' and 'libraries' and it manages all packages and libraries per project basis, installing them into a directory  (as for vendor) inside your project. Actually it doesn't install anything globally that's why it is a dependency manager. Tech Details:                       aws ec2, amazon machine image ubuntu 18.04, Nginx(1.14), php(7.3). Requirement: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, if can't access please visit  blogspot  or  medium 4. nginx installation, if not...
Read more

select2 is not working in AdminLTE

Image
It suffers me a lot. It takes a lot of time from me to research and solve the problem. The problem was very simple. I have faced the problem and solved it. Main problem was select2 doesn't get ajax.googleapis cdn. So, before the jQuery code I have loaded the cdn and it works fine now. Firstly, the code was     <script>         $(document).ready(function() {             $('.js-example-basic-multiple').select2();         });     </script> The problem is looked like the picture below Now after adding the cdn before the script tag. it has been solved the problem and the code looks like below     <script src="https://code.jquery.com/jquery-3.4.1.js" integrity="sha256-WpOohJOqMqqyKL9FccASB9O0KwACQJpFTUBLTYOVvVU=" crossorigin="anonymous"></script>       <script>         $(document).ready(function() {    ...
Read more