Question: I have a table like this:

01-Jul-17      100  

02-Jul-17      100  

03-Jul-17      300  

04-Jul-17      300  

05-Jul-17      500  

06-Jul-17      500  

07-Jul-17      300  

08-Jul-17      400  

09-Jul-17      100  

10-Jul-17      100  

What I want to output is (in this order) by eliminating the continuous duplicates but not all duplicates:  

100  

300  

500  

300  

400  

100  

I cannot select Distinct, as it will eliminate the second instances of 300, 100. Is there a way to achieve this result in MySQL?
Thanks!

Answer: 
Since clockpicker's author didn't expose mindate interface, i can only write the script below by myself. But min datetime won't reflect in the UI( can still select time past 10AM from second clockpicker, but the value won't change). And the question which we can select datetimepicker2 first has not yet been considered.

```
<script>
  var flag = false;
  $(function () {

    $('#clockpicker1').clockpicker({
      placement: 'bottom',
      align: 'right',
      autoclose: true,
      'default': 'now',
      afterDone: function () {
        $('#clockpicker2').get(0).value = $('#clockpicker1').get(0).value;
        flag = true;
      }
    });

    $('#clockpicker2').clockpicker({
      placement: 'bottom',
      align: 'right',
      autoclose: true,
      afterDone: function () {
        if (flag) {
          if ($('#clockpicker2').get(0).value < $('#clockpicker1').get(0).value) {
            $('#clockpicker2').get(0).value = $('#clockpicker1').get(0).value;
          }
        }
      }
    });
  });
</script>

```
Try this:

```
  $("#datetimepicker1").on("dp.change", function (e) {
        $('#datetimepicker2').data("DateTimePicker").minDate(e.date);
    });

    $("#datetimepicker2").on("dp.change", function (e) {
         $('#datetimepicker1').data("DateTimePicker").maxDate(e.date);
    });

```