a problem, thank you# Database - 数据库
a*z
1 楼
How to query stock price table (price in double) and return the the top 10%
of the highest percent return?
Thanks.
of the highest percent return?
Thanks.
e*g
2 楼
俺菜鸟，不是可以Desc 排序吗?
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
a*z
3 楼
percent return needs to be calc'ed, but not allowed to write function.
e*g
4 楼
你调用sql的程序不能算吗？还是说数据库一般都不这么用的?
俺是外行
【在 a*z 的大作中提到】
: percent return needs to be calc'ed, but not allowed to write function.
俺是外行
【在 a*z 的大作中提到】
: percent return needs to be calc'ed, but not allowed to write function.
B*g
5 楼
啥db。
啥version。
其实不用看了，google "over() partition by"
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
啥version。
其实不用看了，google "over() partition by"
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
a*z
6 楼
Thank you all for your info.
date price
1 12
2 23
3 10
...
I was asked to query the table in SQL 2005 to get the top 10% of performance
{(price - prior price)/price} without defining function. Thank you again.
date price
1 12
2 23
3 10
...
I was asked to query the table in SQL 2005 to get the top 10% of performance
{(price - prior price)/price} without defining function. Thank you again.
B*g
7 楼
sql server 呀
SELECT TOP(10) PERCENT 。。。。。。。
performance
【在 a*z 的大作中提到】
: Thank you all for your info.
: date price
: 1 12
: 2 23
: 3 10
: ...
: I was asked to query the table in SQL 2005 to get the top 10% of performance
: {(price - prior price)/price} without defining function. Thank you again.
SELECT TOP(10) PERCENT 。。。。。。。
performance
【在 a*z 的大作中提到】
: Thank you all for your info.
: date price
: 1 12
: 2 23
: 3 10
: ...
: I was asked to query the table in SQL 2005 to get the top 10% of performance
: {(price - prior price)/price} without defining function. Thank you again.
a*z
8 楼
yes, I thought that.
select top 10 percent (price - lag(price))/price pctChange
from ....
order by pctChange
that pctChange needs to be calc'ed from price with 1 period lag. I do not
know if it works.
Thank you very much.
select top 10 percent (price - lag(price))/price pctChange
from ....
order by pctChange
that pctChange needs to be calc'ed from price with 1 period lag. I do not
know if it works.
Thank you very much.
c*e
9 楼
qualify with rank/row_number() etc
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
%
【在 a*z 的大作中提到】
: How to query stock price table (price in double) and return the the top 10%
: of the highest percent return?
: Thanks.
相关阅读
How to write this query in Oracle?菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?我认识的几个人用的数据库Oracle announced it finalized its acquisition of Sun祝愿 dba 们 新年生意兴旺38岁老loser想转行，如果学计算机类是不是不明智菜菜鸟请教：大家都用什么备份啊？SERVER/CLIENT系统，server数据大约200GB70-431考试只有选择题吗?请教Access Report怎么把这个表转换成另外一个表？请问date mining方向好找工作吗？需要学些什么核心课程？mysql mapping and insert question如何格式化sql输出？菜鸟求助: 用 Oracle Sqlldr Control File 能不能改character set?extensive wait SQL*Net message from clientHelp on Oracle QueryOracle在中国金融行业ERP成功验收报告数为零(ZZ)请教一个棘手的问题，关于mysql的日志请教高手，包子谢t-sql chanllege 20