Sometimes when you Run a SQL join query in phpMyAdmin, there will be a situation where the entire server will go down because of the long running SQL query.
Its very easy to select records between two different date in MS SQL and MySQL. Same kind of query will work in both the SQL engines.
Sometimes you may need to connect two different databases for a project and you may feel difficult to do that right?.
Consider the below is the table name “student”
1 | a
2 | b
3 | c
4 | a
5 | d
6 | b
7 | e
Now there are plenty of duplicate records in the above table right?.
Showing the duplicate records is easy in MySQL if you use GROUP BY in the SQL Query you will get it easily.