I have a query in mysql
actual query is:
select f1,f2,f3 from tableName;
I want to remove duplicate value in field f1 and f2 only,actual query is:
SELECT f1,f2,f3
FROM (SELECT f1,f2,f3 FROM tableName GROUP BY f1) AS table1 GROUP BY f2;
good one
ReplyDeleteGreat post thankss
ReplyDelete