select * from (
select * from tbname where data=
(select max(data) maxd from tbname)
select * from tbname where data=
(select min(data) mind from tbname))
select * from tbname where data=
(select max(data) maxd from tbname)
select * from tbname where data=
(select min(data) mind from tbname))
select datetime,data from tablename
where
data in (select min(data) from tablename)
or
data in (select max(data) from tablename);肯定还有更简介的方法。
select a.1,b.1,a.2,b.2 from
(select datetime 1,data 2 from tbname where data=max(data)) a,
(select datetime 1,data 2 from tbname where data=min(data)) b
FROM (SELECT A.DATETIME,A.DATA FROM TEST A where A.DATETIME = (select max(DATETIME) from TEST)) R,
(SELECT B.DATETIME,B.DATA FROM TEST B where B.DATETIME = (select min(DATETIME) from TEST)) S语名可能太搓。