Re: Exclude multiple rows

[Andrew Gilfrin]

you can either use group to filter out the duplicates or use distinct. I'd say distinct would be more appropriate.

mysql> select * from test_dup;
+--------+------+
| emp_id | name |
+--------+------+
| 1 | Dave |
| 1 | Dave |
| 1 | Dave |
| 2 | Mike |
+--------+------+
4 rows in set (0.00 sec)

mysql> select distinct * from test_dup;
+--------+------+
| emp_id | name |
+--------+------+
| 1 | Dave |
| 2 | Mike |
+--------+------+
2 rows in set (0.00 sec)

In effect the distinct is grouping by all the columns in the table.

Andrew Gilfrin
------------------
http://gilfster.blogspot.com
My MySQL related Blog

http://www.mysqldevelopment.com
MySQL Stored Procedure,Trigger, View.... (Just about most things these days) Information