All pastes #741401 Raw Edit

HTL

public text v1 · immutable
·published 2007-10-18 17:49 UTC
rendered paste body
mysql> SELECT * from test;
+---+---+
| a | b |
+---+---+
| a | a |
| a | a |
| a | b |
| b | b |
+---+---+
4 rows in set (0.00 sec)

mysql> SELECT * FROM test WHERE a = 'a';
+---+---+
| a | b |
+---+---+
| a | a |
| a | a |
| a | b |
+---+---+
3 rows in set (0.00 sec)

mysql> SELECT DISTINCT * FROM test WHERE a = 'a';
+---+---+
| a | b |
+---+---+
| a | a |
| a | b |
+---+---+
2 rows in set (0.00 sec)