another_login's questions

我在获取数据时遇到了问题。这里有张桌子：

| ID |                 DDATE | STATUS |
|----|-----------------------|--------|
|  1 | 2000-01-01 01:00:00.0 | aaaaaa |
|  1 | 2000-01-01 02:00:00.0 | aaaaaa |
|  1 | 2000-01-01 03:00:00.0 | aaaaaa |
|  1 | 2000-01-01 04:00:00.0 | aaaaaa |
|  1 | 2000-02-01 05:00:00.0 | bbbbbb |
|  1 | 2000-02-01 06:00:00.0 | cccccc |
|  1 | 2000-02-01 07:00:00.0 | cccccc |
|  1 | 2000-02-01 08:00:00.0 | bbbbbb |
|  1 | 2000-02-01 09:00:00.0 | cccccc |
|  1 | 2000-02-01 10:00:00.0 | cccccc |
|  1 | 2000-02-01 11:00:00.0 | cccccc |
|  1 | 2000-02-01 12:00:00.0 | dddddd |
|  2 | 2000-01-01 13:00:00.0 | aaaaaa |
|  2 | 2000-02-01 14:00:00.0 | aaaaaa |
|  2 | 2000-02-01 15:00:00.0 | aaaaaa |
|  2 | 2000-02-01 16:00:00.0 | aaaaaa |
|  2 | 2000-03-01 17:00:00.0 | bbbbbb |
|  2 | 2000-03-01 18:00:00.0 | cccccc |
|  2 | 2000-03-01 19:00:00.0 | cccccc |
|  2 | 2000-04-01 20:00:00.0 | bbbbbb |
|  2 | 2000-04-01 21:00:00.0 | cccccc |
|  2 | 2000-04-01 22:00:00.0 | cccccc |
|  2 | 2000-04-01 23:00:00.0 | cccccc |
|  2 | 2000-04-01 23:30:00.0 | dddddd |

您需要获取每个 id 的每个状态序列的第一条（及时）记录：

| ID |                 DDATE | STATUS |
|----|-----------------------|--------|
|  1 | 2000-01-01 01:00:00.0 | aaaaaa |
|  1 | 2000-02-01 05:00:00.0 | bbbbbb |
|  1 | 2000-02-01 06:00:00.0 | cccccc |
|  1 | 2000-02-01 08:00:00.0 | bbbbbb |
|  1 | 2000-02-01 09:00:00.0 | cccccc |
|  1 | 2000-02-01 12:00:00.0 | dddddd |
|  2 | 2000-01-01 13:00:00.0 | aaaaaa |
|  2 | 2000-03-01 17:00:00.0 | bbbbbb |
|  2 | 2000-03-01 18:00:00.0 | cccccc |
|  2 | 2000-04-01 20:00:00.0 | bbbbbb |
|  2 | 2000-04-01 21:00:00.0 | cccccc |
|  2 | 2000-04-01 23:30:00.0 | dddddd |

我设法只获得每个 id 的第一个状态，而丢失了重复：

SELECT ID, MIN(DDATE) dd, STATUS FROM Table1
GROUP BY ID, STATUS
ORDER BY ID, dd

请至少告诉我方向。

UPD：可重现的示例http://sqlfiddle.com/#!4/3de9e/1/0。

帮助，请，处理flex'om。有一个代码：

textarea {
    resize: none;
}

.formrow {
    text-align: center;
    display: block;
}

.inout-container {
    display: flex;
    flex-direction: row;
    align-items: flex-start;
    justify-content: center;
}

.column-container {
    display: flex;
    flex-direction: column;
    justify-content: space-between;
}

.inputs-container {
    display: flex;
    flex-direction: column;
}

.ui-element {
    border-radius: 7px;
    border-style: solid;
    border-width: thin;
    text-align: center;
    margin: 2px;
}

.button {
    display: inline-flex;
    background: #b7b7b7;
    padding: 3px;
    cursor: pointer;
    box-shadow: 1px 1px 0px 0px #000;
    user-select: none;
}

<div class="formrow inout-container">
  <div class="column-container">
    <div class="inputs-container">
      <input class="ui-element" type="text">
      <input class="ui-element" type="text">
      <input class="ui-element" type="text">
      <input class="ui-element" type="text">
      <input class="ui-element" type="text">
      <input class="ui-element" type="text">
    </div>
    <div class="buttons-container">
          <div class="button ui-element">Текст</div>
      </div>
  </div>
    <div>
    <textarea class="ui-element" cols="40" rows="15" disabled>Тут текст</textarea>
    </div>
</div>

我无法将“文本”按钮粘贴到块的底部：

是否可以在不明确指定父级的大小的情况下执行此操作？

在 Chrome 浏览器控制台中，我重新创建了真实情况：

var today = new Date(); // undefined
today.getDate() // 24
let date = today // undefined
date.getDate() // 24
let thisDay = date.getDay() // undefined
thisDay // 4
date.setDate(date.getDate() - thisDay + 1) // 1624278668009
date.getDate() // 21
today.getDate() // 21

问题：为什么日期改为今天？