select top 20 * from tableselect top 20 * from table order by bh desc
我是用在 Delphi 的 DecisionQuery 控件的"SQL Query"里边, 在这里写Select语句好像特别挑剔:FArea 表中只有2个字段,TArea做横坐标,SUM( TAreNum )做纵坐标,语句:SELECT TArea, SUM( TAreNum )FROM dbo.FArea GROUP BY TArea可以,但是加上排序就不行了:SELECT top 20 TArea, SUM( TAreNum )FROM dbo.FArea GROUP BY TArea order by TareNum DESC提示“Feild in order by must in result set”。可是只要TArea,SUM( TAreNum )2维的图,应该怎么写?
SELECT top 20 TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea order by TareNum DESC
试试: SELECT top 20 TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea order by SUM( TAreNum ) DESC在不行就(这个应该行的): select top 20 * from ( SELECT TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea ) as a order by Tarenum DESC
我写的: SELECT top 20 TArea, SUM( TAreNum ) as bb FROM dbo.FArea GROUP BY TArea order by bb DESC在SQL查询分析器里边可以顺利执行, 但是在 DecisionQuery 控件里边提示:“Invalid use of keyword.”如果直接写在DecisionQuery 控件的SQL属性的TString...里边,改变它的Active属性为True之后,提示:“ This dimension types for this dataset cannot be determined automatically. You must map the fields to dimensions or summaries with the Decision Cube Editor.”
如果你不是用的ORACLE数据库的话,可以这样试一下: select count(*) from table; select * from table limit count(*)-20,count(*);
但是order by sum(TAreNum) 会提示“Invalid use of keyword.”SELECT top 20 TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea order by SUM( TAreNum ) DESCselect top 20 * from ( SELECT TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea ) as a order by Tarenum DESC我都试过了,还是不行。DecisionQuery控件太讨厌了
我做排序主要是让图表按顺序显示的时候只显示数值比较大的前20个, 现在暂时用: SELECT TArea, SUM( TAreNum ) FROM dbo.FArea WHERE TAreNum > 10 GROUP BY TArea
(In oracle) select .. from .. minus select .. from .. order by a where a<n
select top 20 * from student order by AField Desc //注意你的表中要有一个排序字段,比方为AField,如上写就可以了
在这里写Select语句好像特别挑剔:FArea 表中只有2个字段,TArea做横坐标,SUM( TAreNum )做纵坐标,语句:SELECT TArea, SUM( TAreNum )FROM dbo.FArea GROUP BY TArea可以,但是加上排序就不行了:SELECT top 20 TArea, SUM( TAreNum )FROM dbo.FArea GROUP BY TArea order by TareNum DESC提示“Feild in order by must in result set”。可是只要TArea,SUM( TAreNum )2维的图,应该怎么写?
SELECT top 20 TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea order by SUM( TAreNum ) DESC在不行就(这个应该行的):
select top 20 * from (
SELECT TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea ) as a
order by Tarenum DESC
SELECT top 20 TArea, SUM( TAreNum ) as bb
FROM dbo.FArea GROUP BY TArea order by bb DESC在SQL查询分析器里边可以顺利执行,
但是在 DecisionQuery 控件里边提示:“Invalid use of keyword.”如果直接写在DecisionQuery 控件的SQL属性的TString...里边,改变它的Active属性为True之后,提示:“ This dimension types for this dataset cannot be determined automatically. You must map the fields to dimensions or summaries with the Decision Cube Editor.”
select count(*) from table;
select * from table limit count(*)-20,count(*);
就是它显示的东西不好控制,除非是把要显示的数据都准备好了,放到一个表里边,它就效果很好。否则它的横坐标,纵坐标的值控制挺麻烦。谢谢大家!我再试试
会提示“Invalid use of keyword.”SELECT top 20 TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea order by SUM( TAreNum ) DESCselect top 20 * from (
SELECT TArea, SUM( TAreNum ) as Tarenum FROM dbo.FArea GROUP BY TArea ) as a
order by Tarenum DESC我都试过了,还是不行。DecisionQuery控件太讨厌了
现在暂时用:
SELECT TArea, SUM( TAreNum )
FROM dbo.FArea
WHERE TAreNum > 10
GROUP BY TArea
select .. from ..
minus
select .. from .. order by a
where a<n
order by AField Desc
//注意你的表中要有一个排序字段,比方为AField,如上写就可以了