表tbSample数据如下:
id x y
0 3.4 4.5
1 2.1 0.0
3 5.6 0.2
1、指定两行求和(或者各种加减乘除操作)
select a.x+b.x as totalX,a.x,b.x from tbSample a,tbSample b where a.id=0 and b.id=1
2、
posted on 2010-05-21 20:46 半城烟沙 阅读(202) 评论(0) 编辑 收藏 举报
Powered by: 博客园 Copyright © 2024 半城烟沙 Powered by .NET 8.0 on Kubernetes