Suppress display in a column if the value is equal to the value in another column I have 2 date columns that are displayed side-by-side. I have some dates that are equal. I do not want to display the "equal" dates/duplicate date values in one of the columns.

Example:

    column1     column2
    1-1-2014    1-1-2014


I want to display:

    column1     column2
    1-1-2014          


How do I achieve that?
See the DDL, DML and SQL below, it should get you some (all?) of the way. It's taken from MySQL, but should be fairly generic.

Take a look at this (MS SQL Server) and also this (more general). Check the docco of your particular server for any or all which may apply. 

CREATE TABLE fred 
(
  billy int(11) DEFAULT NULL,
  d1 date DEFAULT NULL,
  d2 date DEFAULT NULL
);

mysql&gt; desc fred;
+-------+---------+------+-----+---------+-------+
| Field | Type    | Null | Key | Default | Extra |
+-------+---------+------+-----+---------+-------+
| billy | int(11) | YES  |     | NULL    |       |
| d1    | date    | YES  |     | NULL    |       |
| d2    | date    | YES  |     | NULL    |       |
+-------+---------+------+-----+---------+-------+
3 rows in set (0.00 sec)

mysql&gt; insert into fred values(1, '20140606', '20140607');
Query OK, 1 row affected (0.09 sec)

mysql&gt; insert into fred values(1, '20140606', '20140606');  &lt;&lt;&lt;=== SAME
Query OK, 1 row affected (0.07 sec)

mysql&gt; insert into fred values(1, '20140607', '20140608');
Query OK, 1 row affected (0.06 sec)

mysql&gt; select * from fred;
+-------+------------+------------+
| billy | d1         | d2         |
+-------+------------+------------+
|     1 | 2014-06-06 | 2014-06-07 |
|     1 | 2014-06-06 | 2014-06-06 |  &lt;&lt;=== SAME
|     1 | 2014-06-07 | 2014-06-08 |
+-------+------------+------------+
3 rows in set (0.00 sec)

SELECT billy, d1, 
  CASE
    WHEN d1 = d2 
      THEN NULL
    ELSE 
      d2
  END AS d2 
FROM fred;

+-------+------------+------------+
| billy | d1         | d2         |
+-------+------------+------------+
|     1 | 2014-06-06 | 2014-06-07 |
|     1 | 2014-06-06 | NULL       | &lt;&lt;== ***
|     1 | 2014-06-07 | 2014-06-08 |
+-------+------------+------------+