Re: [SQL ] 關於select資料
測試環境:SQL Server 2008
select avg(p_speed) as avg_speed,avg(p_time) as avg_time from
(
select (speed1+speed2)/2 as p_speed,(t2-t1) as p_time from
(
select [name] ,speed as speed1,[time] as t1
from aaa2 where place='0'
) as tp1
inner join
(
select [name] ,speed as speed2,[time] as t2
from aaa2 where place='1'
)as tp2 on tp1.[name]=tp2.[name]
) as t
=========================
執行結果
avg_speed avg_time
37 54
完成
--
我討厭欄位名稱叫name或time >"<
--
※ 發信站: 批踢踢實業坊(ptt.cc)
◆ From: 61.224.44.230
※ 編輯: decadance 來自: 61.224.44.230 (11/22 03:50)
推
11/22 15:28, , 1F
11/22 15:28, 1F
討論串 (同標題文章)
完整討論串 (本文為第 3 之 3 篇)：