SQL 命令 : get min date and hour from table

Question

SQL 命令:从表中获取最小日期和小时

TblAzmon:Acode(pk)  |  Aname       |  Adate        |  Ahour  |  ADcode_fk----------------------------------------------------------------------------1           system         1358/05/05       08:00       22           graphic        1389/05/05       08:00       13           simulation     1392/05/06       07:30       14           math           1389/05/05       09:00       1

I want the output date and time for the manager (ADcode) to get the smallest.

Desired output: [Where ADcode_fk='1']

Acode   |   Adate      | Ahour----------------------------------2          1389/05/05   08:00

SQL command:

select Acode,Adate,Ahour from TblAzmon<br>
where Adate in (select min(Adate) from TblAzmon where ADcode_fk='1')
And Ahour in (select min(Ahour) from TblAzmon where ADcode_fk='1')

输出:----------->0 行 - NULL

提示:所有列都是文本类型。除了列Acode。

请编写SQL代码。

Answer 1

你可以这样做，使用 order by和 top :

select top 1 *
from tblAzmon a
order by Adate, Ahour