select
a.ProjectID ,
a.P_temp ,
a.Recordtime
from
tabname a
where
a.P_temp = (select max(P_temp) from tabname where ProjectID=a.ProjectID)
a.ProjectID ,
a.P_temp ,
a.Recordtime
from
tabname a
where
a.P_temp = (select max(P_temp) from tabname where ProjectID=a.ProjectID)
解决方案 »
- 怎么在查询分析器里查看字符串内容
- SQL查询并创建视图
- 函数返回调用的存储过程的表数据!
- SQLServer2005导出表到Oracle10g,提示导出成功,但是oracle查没有数据
- mssql insert触发器中获取自增列的值
- 求存储过程,用来删除数据库里所有数据表里的数据,我需要完整的代码??谢谢
- SQL循环比较的问题
- 一存储过程,按日,周,月,季计算总额,整了几天了总是不动,求高人指点
- 急需解决的问题!一个向数据库写入时间数据的问题!多谢高手指教!100分!
- 挑战高手—SQLSERVER2000 中文长度限制问题!
- 问一条sql语句.
- 急~~~~~~~~~~~~~~~~~~~请问在存储过程中异常怎么处理?
ProjectID (项目编号)
P_temp (温度)
Recordtime (记录时间)那么,查询语句如下:
----------------------------------------------------------------------------
select
a.ProjectID ,
a.P_temp ,
a.Recordtime
from
tabname a
where
a.P_temp = (select max(P_temp) from tabname where ProjectID=a.ProjectID)
FROM 表 A
WHERE P_temp=(SELECT MAX(P_temp) FROM 表)
And Recordtime =(SELECT MAX(Recordtime) FROM 表
Where Recordtime = A.Recordtime )
Union All
SELECT P_temp, Recordtime
FROM 表 A
WHERE P_temp=(SELECT Min(P_temp) FROM 表)
And Recordtime =(SELECT Min(Recordtime) FROM 表
Where Recordtime = A.Recordtime )
FROM 表 A
WHERE P_temp=(SELECT MAX(P_temp) FROM 表 Where ProjectID = A.ProjectID )
And Recordtime =(SELECT MAX(Recordtime) FROM 表
Where Recordtime = A.Recordtime And ProjectID = A.ProjectID )
Union All
SELECT ProjectID, P_temp, Recordtime
FROM 表 A
WHERE P_temp=(SELECT Min(P_temp) FROM 表 Where ProjectID = A.ProjectID )
And Recordtime =(SELECT Min(Recordtime) FROM 表
Where Recordtime = A.Recordtime And ProjectID = A.ProjectID )
from
tablename A
inner join
(select max(P_temp) as maxP_temp ,Recordtime from tablename group by Recordtime) B
on A.Recordtime=B.Recordtime and A.P_temp =B.maxP_temp
------------------------------------------------------------------
select
a.P_temp_A,
(select Recordtime from tabname P_temp=a.P_temp_A),
P_temp_I,
(select Recordtime from tabname P_temp=a.P_temp_I),
...
a.Item16_A,
(select Recordtime from tabname Item16=a.Item16_A),
a.Item16_I,
(select Recordtime from tabname Item16=a.Item16_I)
from
(select
max(P_temp) as P_temp_A,
min(P_temp) as P_temp_I,
max(Item2) as Item2_A,
min(Item2) as Item2_I,
...
max(Item16) as Item16_A,
min(Item16) as Item16_I,
from tabname) a
a.P_temp_A,
(select top 1 Recordtime from tabname P_temp=a.P_temp_A),
P_temp_I,
(select top 1 Recordtime from tabname P_temp=a.P_temp_I),
...
a.Item16_A,
(select top 1 Recordtime from tabname Item16=a.Item16_A),
a.Item16_I,
(select top 1 Recordtime from tabname Item16=a.Item16_I)
from
(select
max(P_temp) as P_temp_A,
min(P_temp) as P_temp_I,
max(Item2) as Item2_A,
min(Item2) as Item2_I,
...
max(Item16) as Item16_A,
min(Item16) as Item16_I,
from tabname) a