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

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

nginx installation on aws ec2 instance ami ubuntu 18.04

Image
Introduction:                     Nginx is an open source software for web serving, proxying, caching, media streaming, load balancing and more. This is the fastest web server. Most server administrator like Nginx. We also choose nginx for our web deployment on aws. Requirement: 1. aws account access 2. running ec2 instance 3. accessing the ec2 instance, to create ec2 please visit  https://zrshishir.blogspot.com/2019/10/how-to-create-ec2-instance-on-aws.html or  https://medium.com/@zrshishir/how-to-create-ec2-instance-on-aws-amazon-web-service-ami-ubuntu-18-04-abff3b7fd922 Step1: Installation of nginx using terminal. open up your terminal and execute the following command    $ sudo apt update    $ sudo apt install nginx Step2: Adjusting ubuntu firewall (ufw), if you think it is needed to install then you can work with this step. Firstly you should show the ufw list with the execution foll...
Read more

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