用子查询
SELECT (SELECT avg(num) FROM table WHERE xuehao=1111111 AND num < 10) + sum(num) WHERE num > 10
SELECT (SELECT avg(num) FROM table WHERE xuehao=1111111 AND num < 10) + sum(num) WHERE num > 10
解决方案 »
- web控件网页的go method标记问题
- 散分。局域网WinForm程序自动升级功能实现
- dataset模糊搜索选中datagridview
- 自定义WebBrowser控件中打开showModalDialog窗体
- Winform怎么做比较好的Textbox之类的验证?
- C# 高手请进
- 问一下大家 public test (string text) : this() { Text = text; } 是什么意思啊,谢谢,在线等**********
- 数据连接字符串到底哪里出错
- C#中如何实现鼠标拖拽图片的效果?
- 谁有这么漂亮的界面代码哦?http://www.chinaui.com/ui_view.asp?id=483的界面该怎么实现呢?
- 如何快速定位dataset1.table[0]的位置
- 怎样将dataGrid绑定到dataReader上呀
FROM table
WHERE num > 10
select avg( a.num ) + sum( b.num ) AS "NUM"
from table a
left join table b on a.id = b.id and b.num > 10
where a.id = 11111 and a.num < 10
from
(select AVG(num) as a1
from t
where 学号=111111 and num<10) a, (select SUM(num) as b1
from t
where 学号=111111 and num>10) b