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.
相关阅读
Help Please!Questions for e-commerce website newbie.菜鸟问题: 请问现在的数据库的远程管理能做到那些?是否可以完全取代本地机器的管理?a newbie's question about oraclehow to know how many uses exists in my db?Re: Oracle DBA 考试资料？Got demo testRe: [转载] Oracle将发布最新数据库产品Oracle9i！follow-upHow to create temp table in DB2 ?如何对ORACLE的结果既分页又排序？Is database very useful/marketable?请问:如何在Oracle8开始?开发害虫管理的专家系统elp!求助：SQL Fulltext search不干活了。How to let sql plus connect to the local database in personal oracle?请教: 如何用Perl连接Oracle数据库?高手指点：如何让Windows NT上的Mircosoft Access与MVS mainframe上的COBOL/DB2一起工作？请解释几个概念(新手请教)oracle里面怎幺加user啊？Oracle SQL code question???????????????oracle里有些怪怪的表，不只是哪里来的？MCDBA, where is the braindump website for MCDBA?