怎样可以使控件Query或者控件Table中的数据,按自身的字段任意排序 请帮忙 !!!
无奈在sql里排序吧 还是不行,请看下列语句:SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM (angpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY xiaoshoue DESC在这条sql语句中 我希望给新产生的字段xiaoshoue 排序可怎么也通不过,如何解决?? SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM(shangpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY SUM(shangpinxiaoshou.shishoujia) DESC这样做了也不行
无奈在sql里排序吧 还是不行,请看下列语句:SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM (angpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY xiaoshoue DESC在这条sql语句中 我希望给新产生的字段xiaoshoue 排序可怎么也通不过,如何解决?? SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM(shangpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY SUM(shangpinxiaoshou.shishoujia) DESC这样做了也不行
解决方案 »
- delphi serverscoket问题
- 使用execute出现错误!紧急求助!!
- ADOTable的怪问题
- PowerPointApplication打开并播放的幻灯片,如何知道是第几张?
- 请教一个简单问题,我第一次写触发器,请高手指教,谢谢!
- 关于Timage的问题
- 哪里能下载D5的ADO补丁?
- 我刚接触DELPHI,对编程这个领域涉足不深,请问我是否应该订阅《程序员》呢,他面向的对象适合我吗??
- 怎样使窗体变为全屏?
- 关于集合的问题
- 我想在按钮按下时清空DBLOOKUPCOMBOBOX里的内容,但把LISTFIELDINDEX设为-1时不能清空,怎样清空呢?
- 高手都去那了???????1000分奉上,有人答吗。
(
SELECT shangpinruku.shangpinpinzhong, SUM(shangpinxiaoshou.shishoujia)
AS xiaoshoue, SUM(shangpinxiaoshou.shishoujia) -
SUM (angpinruku.jinhuojiage) AS lirun
FROM shangpinruku INNER JOIN rukuchima ON shangpinruku.shangpinrukuid = rukuchima.shangpinrukuid INNER JOIN shangpinxiaoshou ON rukuchima.tiaoma = shangpinxiaoshou.shangpinbianhao
WHERE (shangpinxiaoshou.xiaoshoushijian >= '2001-01-01')
GROUP BY shangpinruku.shangpinpinzhong
ORDER BY xiaoshoue DESC
)
order by xiaoshoue