I have this table that contains around 10 columns. There are some datas that are completely identical to all of the columns. Let say for example
|Gender| |Name| |Age|
M Mark 10
M Mark 10
M Alex 12
F Alex 12
F Alex 15
My output should be
|Gender| |Name| |Age|
M Mark 10
M Alex 12
F Alex 12
F Alex 15
I know how to distinct on one column like for age:
|Gender| |Name| |Age|
M Mark 10
M Alex 12
F Alex 15
What I need is to only group/distinct the rows, if all of the column datas are identical.