❶ php中oracle sql 求和結果輸出
$ssid = oci_parse($conn, $sql_sum);
oci_execute($ssid, OCI_DEFAULT);
$rowr = oci_fetch_array($ssid, OCI_ASSOC);
var_export($rowr);
❷ 在oracle資料庫中,要求兩個欄位的和要怎麼寫sql語句
1.如果都是數字類型的直接把這兩個欄位相加
select
a+b as ab
from S ;
或者你的意思是 select sum(a+b) from S;
2.如果是不同的欄位類型就不能求和了，但是可以使用「||」或者CONCAT()函數
2.1 select a||b from S;
2.2 select concat(a,b) from S;
❸ oracle時間相加問題，比如我想在一個時間上加上3個小時 ，sql語句怎麼寫啊
select sysdate,to_char(sysdate+3/24,'yyyy-mm-dd HH24:MI:SS') from al; --加3個小時
--------------其他的：
select sysdate,add_months(sysdate,12) from al; --加1年
select sysdate,add_months(sysdate,1) from al; --加1月
select sysdate,to_char(sysdate+7,'yyyy-mm-dd HH24:MI:SS') from al; --加1星期
select sysdate,to_char(sysdate+1,'yyyy-mm-dd HH24:MI:SS') from al; --加1天
select sysdate,to_char(sysdate+1/24,'yyyy-mm-dd HH24:MI:SS') from al; --加1小時
select sysdate,to_char(sysdate+1/24/60,'yyyy-mm-dd HH24:MI:SS') from al; --加1分鍾
select sysdate,to_char(sysdate+1/24/60/60,'yyyy-mm-dd HH24:MI:SS') from al; --加1秒
❹ oracle中SQL如何把兩個表中相關數據相加
樓主說的相加是指數值類型的相加還是指合並結果集？如果是數值類型的列相加只需要把兩張表用合適的關聯條件關聯起來進行查詢，列相加即可；如果是合並結果集需要注意列順序，子查詢對應列的類型必須要一致，用UNION 或UNION ALL關鍵字。
❺ sql語句怎麼來對日期進行相加減
日期增減計算
使用DATEADD 函數
1> SELECT '現在' AS [日期], GETDATE() AS [數據]
2> UNION ALL
3> SELECT '下一秒' AS [日期], DATEADD(ss, 1, GETDATE() ) AS [數據]
4> UNION ALL
5> SELECT '下一分' AS [日期], DATEADD(mi, 1, GETDATE() ) AS [數據]
6> UNION ALL
7> SELECT '下一小時' AS [日期], DATEADD(hh, 1, GETDATE() ) AS [數據]
8> UNION ALL
9> SELECT '明天' AS [日期], DATEADD(dd, 1, GETDATE() ) AS [數據]
10> UNION ALL
11> SELECT '下周' AS [日期], DATEADD(ww, 1, GETDATE() ) AS [數據]
12> UNION ALL
13> SELECT '下月' AS [日期], DATEADD(mm, 1, GETDATE() ) AS [數據]
14> UNION ALL
15> SELECT '下季度' AS [日期], DATEADD(qq, 1, GETDATE() ) AS [數據]
16> UNION ALL
17> SELECT '明年' AS [日期], DATEADD(yy, 1, GETDATE() ) AS [數據]
18> go
日期 數據
-------- -----------------------
現在 2011-02-11 21:27:15.750
下一秒 2011-02-11 21:27:16.750
下一分 2011-02-11 21:28:15.750
下一小時 2011-02-11 22:27:15.750
明天 2011-02-12 21:27:15.750
下周 2011-02-18 21:27:15.750
下月 2011-03-11 21:27:15.750
下季度 2011-05-11 21:27:15.750
明年 2012-02-11 21:27:15.750
(9 行受影響)
兩個日期之間的差值
1> SELECT '年' AS '日期部分', DATEDIFF(yy, '2012-12-21', GETDATE()) AS [數值]
2> UNION ALL
3> SELECT '季度' AS '日期部分', DATEDIFF(qq, '2012-12-21', GETDATE()) AS [數值]
4> UNION ALL
5> SELECT '月' AS '日期部分', DATEDIFF(mm, '2012-12-21', GETDATE()) AS [數值]
6> UNION ALL
7> SELECT '日' AS '日期部分', DATEDIFF(dd, '2012-12-21', GETDATE()) AS [數值]
8> UNION ALL
9> SELECT '周' AS '日期部分', DATEDIFF(ww, '2012-12-21', GETDATE()) AS [數值]
10> UNION ALL
11> SELECT '時' AS '日期部分', DATEDIFF(hh, '2012-12-21', GETDATE()) AS [數值]
12> UNION ALL
13> SELECT '分' AS '日期部分', DATEDIFF(mi, '2012-12-21', GETDATE()) AS [數值]
14> UNION ALL
15> SELECT '秒' AS '日期部分', DATEDIFF(ss, '2012-12-21', GETDATE()) AS [數值]
16> go
日期部分 數值
---- -----------
年 -1
季度 -7
月 -22
日 -679
周 -97
時 -16275
分 -976470
秒 -58588175
(8 行受影響)
❻ SQL中如何將兩個查詢結果相加
做個簡單的。
兩個數據表db1,db2
查詢結果A是從數據表db1獲取的：
select names, sale from db1
查詢結果B是從數據表db2獲取的：
select names, sale from db2
則查詢結果C：
select names,sum(sale) as sale
from
(select names, sale from db1
union
select names, sale from db2
)
group by names
❼ 關於oracle求和的sql怎麼寫
SELECT TIME,SUM(total)
FROM
(
SELECT sampling_time AS TIME, (MAX(A) - MIN(A)) AS total
FROM data
WHERE id = '1'
AND sampling_time >= '2013-08-24 00:00:00'
AND sampling_time < '2016-08-25 00:00:00'
GROUP BY sampling_time
ORDER BY sampling_time;
UNION
SELECT sampling_time AS TIME, (MAX(A) - MIN(A)) AS total
FROM data
WHERE id = '2'
AND sampling_time >= '2013-08-24 00:00:00'
AND sampling_time < '2016-08-25 00:00:00'
GROUP BY sampling_time
ORDER BY sampling_time
) GROUP BY TIME