MYSQL DISTINCT

[daredavil82]

hello everyone...

i like to know what is a suitable mysql clause instead of DISTINCT clause? i mean which clause same meaning and can produce same result as DISTINCT clause? how about GROUP BY? can i use GROUP by instead of DISTINCT clause?

[xaprb]

In some cases, yes. But you didn't give enough information for me to really answer you.