0

Show only one record or row in MySQL, SQL 2005, SQL 2008, PostgreSQL

mysql_thumbnail

The answer for this question is very simple if you already have experience in multiple SQL Servers such as MySQL, MS SQL 2005, PostgreSQL etc.,┬áBut, if you have knowledge in any one of the SQL engine and not experienced other… Continue Reading

0

Delete duplicate records except one record in MySQL

mysql_thumbnail

This kind of questions are asked many times in many Interviews, so better we should know how to answer them. Let’s create a table first and insert some dummy duplicate records:

Run this above query in a SQL browser… Continue Reading