To get distinct data without using distinct keyword, use GROUP BY clause.

• Use GROUP BY clause with the column name to group the data by that column.

• Use aggregate functions like COUNT, SUM, AVG, etc. to...read more