|
c**t
发帖数: 2744 | 2 Oracle doesn't have top n query.
select x.salary
from (
select salary, rank() over (order by salary desc null last) as rnk fro
m payroll
) x
where x.rnk < 10;
or
select x.salary from (select salary from payroll order by salary desc)
where rownum < 10; |
|
|
n********6
发帖数: 1511 | 4 oracle 里面有TABLE: PAYROLL(ID, ..., Salary)
如果我
SELECT TOP 10 Salary
FROM PAYROLL
ORDER BY Salary Desc
能不能得到Salary最高的10条记录？
我记得TOP是随机读取的。是否有高人解释一下？ |
|
|
w*******y
发帖数: 60932 | 6 6pm.com has Nike sneakers for men and women up to 75% off plus free shipping
. Sale ends tonight at midnight.
Here is the link
Men's Link:
http://www.6pm.com/nike~1?s=isNew/desc/goLiveDate/desc/recentSa
#!/nike-shoes/CK_XAVIBb-ICAgoB.zso?s=isNew/desc/goLiveDate/desc/
recentSalesStyle/desc/" rel="nofollow" target="_blank" onclick="_gaq.push(['
_trackEvent', 'thread', 'click', '3764048 - up-to-75-off-men-and-women-nike-
sneakers-plus-free-shipping-at-6pm.com']);">http://www.6pm.com/nike~1?s=isNew.... 阅读全帖 |
|
w*******y
发帖数: 60932 | 7 6PM.com is having a sale on Sperry Top-Siders with discounts up to 60% off.
Free shipping on all orders. Pretty wide selection and most sizes are still
available. Sperry Top-siders generally fit a size down/half a size down
from my experiences.
Guys:
http://www.6pm.com/sperry-top-sider-shoes/CK_XAVICmAHiAgIKAQ.zs
#!/sperry-top-sider-men-shoes/CK_XAVICmAHAAQLiAgMKARg.zso?s=isNew/desc/
goLiveDate/desc/recentSalesStyle/desc/" rel="nofollow" target="_blank"
onclick="_gaq.push(['_trackEvent', 'threa... 阅读全帖 |
|
w*******y
发帖数: 60932 | 8 Tons of new markdowns on boots at 6pm.com:
http://www.6pm.com/search/null/filter/pricingTag/"Global70
#!/search/null/filter/pricingTag/%22Global70Shoes%22/zc1/%22Shoes%22/zc2/%
22Boots%22/sort/percentOff/desc" rel="nofollow" target="_blank" onclick="_
gaq.push(['_trackEvent', 'thread', 'click', '4064234 - many-boots-on-sale-
7080-off-keen-north-face-patagonia-steve-madden-nine-west-crocs-at-6pm.com-
fs']);">boots at 6pm.com [boots at 6pm.com:
http://www.6pm.com/search/null/filter/pricingTag/"Glo... 阅读全帖 |
|
|
|
z***y
发帖数: 7151 | 11 这个不奇怪啊。
你可以看一看那个procedure, 你看里面有几个对temp table 的改变， 这些数据的改
变都会触发
recompilation。
我这个版本是2008 SP2的。
create procedure sys.sp_replmonitorrefreshagentdata
as
begin
set nocount on
declare @retcode int
,@agent_id int
,@agent_id2 int
,@publisher_id int
,@xact_seqno varbinary(16)
,@logreader_latency int
,@publisher_db sysname
,@publication sysname
-- security check
-- Has to b... 阅读全帖 |
|
e*n
发帖数: 1511 | 12 【 以下文字转载自 Stock 讨论区 】
发信人: mitbbs2020 (bbc), 信区: Stock
标 题: Re: 【Stragety论坛】Trading with correlations.
发信站: BBS 未名空间站 (Sun Jul 25 19:52:04 2010, 美东)
用option当然可以，但不是必须，
用option可以得到更高的leverage，
但是缺点是散户量小，不容易实现market neutral。
比如1.37的hedge ratio，你要long 137和short 100个才能实现。
13和10就不那么好，而且不容易adjust，看附图就知道不怎么neutral的情况。
说stock不便于对冲，这点我不懂你什么意思。
这本身就是market neutral的strategy。
我测试过DISCA和AXP（paper account)，追踪了至少2个月，涨跌幅从来没超过3%的，
但是这反过来说明这不是一对好的pair。
别的pair，没有任何leverage，一年可以做到100%以上的也有，如果我实际做stock到
这个%，
已经很满意了... 阅读全帖 |
|
a*********0
发帖数: 4998 | 13 3%还不错
现在大部分都是up to 3%，最多给3%，很多东西不给
FAQsContact Us
# A B C D E F G H I J K L M N O P Q R S T U V W X Y Z
Amazon Cashback, Hot Deals, and Discounts
Amazon started to provide cashback on certain products. However, the
categories keep changing. Please refer to the cashback provider's site for
detailed categories that are eligible for cashback. As far as we know, the
following providers have some cashback for certain categories.
Cashback Rate desc desc Cashback Site desc Bonus desc ... 阅读全帖 |
|
|
|
|
b***e
发帖数: 1419 | 17 /*
Here's a solution with JS, O(n) time and O(1) space.
You can copy&paste the full body of this post and run it in
a browser console.
*/
var minCandies = function(children) {
var maxHeight = children.length;
var state = 'desc';
var height = maxHeight;
var accumulated = 0;
var count = 0;
for (var i = 0; i < children.length - 1; i++) {
accumulated += height;
count++;
if (state == 'desc') {
if (a[i] > a[i+1]) {
height--;
... 阅读全帖 |
|
i*****9
发帖数: 293 | 18 有下面这四个表和下面这几个要求，怎么写比较好能得到我想要的结果? 多谢
1，先选出USERACC_FOR_DOM_REP的所有的值：username, account_status, target_db.
2，再从上面的结果中除掉所有EXCEPTION_ACC的username(条件是EXCEPTION_ACC里的
username和target_db是USERACC_FOR_DOM_REP的)。
3, 再从上面的结果中除掉所有MAX_USER_LOGIN的username(条件是MAX_USER_LOGIN里的
username和target_db是USERACC_FOR_DOM_REP的，外加LAST_LOGIN < sysdate -90)。
4, 再从上面的结果中除掉所有MYTABLE的username(条件是MYTABLE里的username和
target_db是USERACC_FOR_DOM_REP的
SQL> desc USERACC_FOR_DOM_REP
Name Null? Type
... 阅读全帖 |
|
g****y
发帖数: 436 | 19 一个cpp文件的头部：
#include "BEDFileData.h"
#include
using namespace std;
using namespace affxbed;
#pragma warning(disable: 4996)
然后中间有用到 strlen之类的函数，比如：
void BEDFileData::FormatTrack(const char *name, const char *desc)
{
char line[256];
if (desc && strlen(desc) > 0)
sprintf(line, "%s\"%s\" description=\"%s\"", TRACK_LINE_
START, name, desc)
;
else
sprintf(line, "%s\"%s\"", TRACK_LINE_START, name);
track=line;
}
编译的时候，报错说：
error: |
|
d******e
发帖数: 2265 | 20 开始试水 akka-slick-spray-play 技术stack. 大吃一惊。
先看fsm.
case class Supplier(id: Option[Int],name: String,desc: String)
case class SimpleSupplier(name: String,desc: String)
trait Suppliers extends Profile{
import profile.api._
class Suppliers(tag: Tag) extends Table[Supplier](tag, "SUPPLIERS") {
def id = column[Int]("id", O.PrimaryKey, O.AutoInc)
def name = column[String]("userID")
def desc = column[String]("last_name")
def * = (id.?, name, desc) <> (Supplier.tupled, Supplier.unapply... 阅读全帖 |
|
s******8
发帖数: 102 | 21 data youwant;
set yourdata end=last;
if length(strip(put(terid,best32.))) gt length(strip(put(lag(terid),32.)))
then do;
curentterid=terid;
curentparentid=parentid;
curentdesc=desc;
ln=length(strip(put(lag(terid),32.)));
call missing(terid,parentid,desc);
do j= 1 to ln;
terid=sum(terid,9*10**(j-1));
end;
if ln gt 2 then parentid=terid-9*10**(ln-2)-9*10**(ln-1);
output;
terid=curentterid;
parentid=curentparentid;
desc=curentdesc;
output;
end;
else output;
if last then do;
ln=length(strip(put(teri... 阅读全帖 |
|
|
w*******y
发帖数: 60932 | 23 6pm.com has a large sale on Patagonia items. The ones I found to be very
good are on some of Patagonia's best jackets.
The primo and powder bowl jackets are both 45% off. Use FW for additional 4%
cashback.
I own the powder bowl jacket and live in the mountains. This is an amazing
jacket and rarely half off
Some jackets show 30% on main page but once you go to product page it goes
down to 45%
LINK:
http://www.6pm.com/patagonia~1?s=percentOff/desc#!/patagonia-me
#!/patagonia-men-coats-outerwear/CK... 阅读全帖 |
|
|
w*******r
发帖数: 2953 | 25 改完的程序在下面，这下疾病可以随便定义了，也可以治病了。
想给给个病安个计数器，记得好像有个什么关健词可以让所有的object改动的都是
同一个变量而不是各自的变量(counter),记不起来了，所以这个counter打印得
不对，有知道的告诉我一声。
#include
#include
#include
using namespace std;
class Disability
{
public:
Disability(){counter = 0; };
Disability(string, string);
~Disability(){};
string get_disease_name() const { return name; };
string get_disease_desc() const { return desc; };
void incr_sick_human_counter() {counter++; };
unsigned long get_hum... 阅读全帖 |
|
j*****y
发帖数: 1408 | 26 今天6pm有deal，有几双17.76，不知道算不算好deal
www.6pm.com/boys-shoes~6?s=isNew/desc/goLiveDate/desc/recentSalesStyle/desc/
#!/see-kai-run-kids-boys-shoes/CK_XAVoCsglqAQXAAQTiAgQBGAsN.zso?s=price/asc
可是不明白鞋号中的 toddler 和 little kid 有啥区别？是先1-13toddler再1-
13little kid？ |
|
n****6
发帖数: 72 | 27 现在在办EB2，因为现在的工作在毕业前又开始了，所以不能用来申请。 于是和老板商
量办好绿卡换个部门，用新部门的职位申请。 刚把新部门的job description发给律师
。 律师现在要experience letter证明job desc上的requirements我都符合。并且说因
为job desc上写的都是"working with" or "using" something,我要用experience
letter 证明以前工作中用过这些。可是大部分东西我以前都没干过，请教一下这种情
况怎么解决？想着即使老板给写上我干过这些东西，我也不能要啊，因为这样就不能证
明新工作和旧工作差异打过50%了吧。准备和老板商量一下改一下词，把 "working
with" 和 "using" 改成"knowledge in"之类的不知行不行？如果可以，还有什么词可
以用？我以前在学校学过一些新职位的东西并且也考了一两个证书。
如果把我没干过requirement都改成 “knowledge in”，而我干过的还写成“working
with”，会不会也不好？听说job desc太tail... 阅读全帖 |
|
s***f
发帖数: 173 | 28 比如我要显示如下的表格:
Project Activity Hours Period Employee name
以上是表格的所显示的FIELD NAME, 但是现在公司需要将PROJECT , ACTIVITY 这些FIELD
NAME 派序(SORT),这本来不难. 比如,可以将PROJECT 做个连接,将它的
HREF = "?ORDERBY=PROJECT" 就行了,然后再REQUEST.QUERYSTRING("ORDERBY")一下就可
以了, 但是现在问题是, 点机PROJECT的时候又要求切换的排序,比如,第一次CLICK的时候
是ASC, 第2次CLICK时就是DESC了,第3次的时候又是ASC... 请教高手, 谢了!
或者哪里有有关的代码也可以,万分感激.
再补充一下, 如果是在PROJECT上做2个连接,一个是ASC,令一个是DESC, 那么这个不符合
我以上的CASE. 目前的CASE是,一个连接要在ASC, DESC之间切换. |
|
y********o
发帖数: 2565 | 29 Or start from
desc user_indexes;
desc dba_indexes;
desc all_indexes;
Just learned it a few days ago. It is still warm in my memory. This reply h
elps me memorize it. :) |
|
y********o
发帖数: 2565 | 30 The one you gave below gives an error:
SQL> select salary from emp order by salary desc where rownum=2;
select salary from emp order by salary desc where rownum=2
*
ERROR at line 1:
ORA-00933: SQL command not properly ended
I tried this:
SQL> select salary from emp where rownum = 2 order by salary desc ;
Which returns:
no rows selected
__Note__: emp is just a synonym of hr.employee. |
|
g****y
发帖数: 188 | 31 Q1：
Given the following SAS program:
proc sql;
select product,type,sum(sales) as revenue
from one
group by product,type;
quit;
which one of the following clauses should be added to the program to sort
the output by PRODUCT and decreasing REVENUE?
A. order by 1,3
B. order by 1,3 desc
C. order by product, revenue desc
D. order by product, desc revenue
为什么答案是B？C不是一样吗？
Q2：
Which SET statement option names a variable but contains the number of the
observation to read during the current iteration of t... 阅读全帖 |
|
w*******y
发帖数: 60932 | 32 6pm.com has Converse shoes up to 80% off - sizes for the whole family from
infants to men/women sizes. (Some infant/toddler styles as low as $5 - $5.
60)
Free shipping with $100+ or $6.95 flat rate. (Sorry, wish there was a free
shipping deal )
Link:
http://www.6pm.com/search/shoes/filter/productTypeFacet/"Shoes"/brandNameFacet/"Converse OR Converse Kids"/categoryFacet/"Shoes"/sort/percentOff/desc
Also, if you have boys like me who want PF Flyers, 40% off and up to 71% off
on some styles. (j... 阅读全帖 |
|
|
|
|
g******t
发帖数: 11249 | 36 CS本科课程
你会写吗？
Find the courses that can help people find a job by training people toward
the positions that has the most openings due to lack of qualified workers.
WITH Order_table AS(
SELECT pos_code,Unfilled_jobs
FROM
(SELECT pos_code, COUNT(job_code) AS Unfilled_jobs
FROM
(SELECT POS.pos_code, J.job_code
FROM Position POS, Job J
WHERE J.pos_code=POS.pos_code
MINUS
SELECT POS.pos_code, J.job_code
FROM Person P, Position POS, Job J
WHERE J.pos_code=POS.pos_code AND J.per_id=P.... 阅读全帖 |
|
h*********n
发帖数: 915 | 37 Model 2010 Cooper S
Color Code / Desc.
A59 Laser Blue metallic paint
Upholstery Code / Desc.
K8E1 Grey/Carbon Black Leatherette
Options:
205 - STEPTRONIC automatic trans.
522 - Xenon headlights
6ND - Bluetooth and USB/iPod adapter
785 - White turn-signal lights
MSRP 25850， invoice 23335，dealer ask 23202 + ttl. OTD大概要25752.
现在有1.9% apr for 5-yr，但是附加在这个low apr promotion上free package就没有
了。本来可以五选一：
Automatic transmission(0205);
Premium package(ZPP or ZP2);
Mayfair Package(7HA);
Camden Package(7HB |
|
a**s
发帖数: 1892 | 38 在www.tirerack.com上搜了有不同的价格。这两个评价比较好。costco要 $130说是质
量最好的，请大家指点一下，谢谢！
Goodyear Eagle LS-2 (Grand Touring All-Season)
* Size: 195/65R15
Sidewall Style: Blackwall
Serv. Desc: 91HLoad Index 91 = 1356lbs (615kg) per tire
Speed Rating "H" = 130mph (210kph)
UTQG: Treadwear: 740
Traction: A
Temperature: B
740 A B
* Price: $111.00 (each)
Estimated Availability: In Stock
ook Optimo H727 (Standard Touring All-Season)
* Size: 195/65R15
Sidewa... 阅读全帖 |
|
C***2
发帖数: 62 | 39 最近想买二手车,准备使用2-3年, 新手. 这几天看了一些车, 不太懂,请大家看看这
些车,提提建议! 谢谢!
1.2004HYU NDAI ELANTRA GLS/GT
ADVERTISED PRICE: $5,500 MILEAGE:71585
TRANSMISSION: Automatic
2. 2007 FORD FOCUS SEL
$6,500 MILEAGE: 82425
VIN:1FAHP34N77W 275657 ENGINE DESC:2.0L I4 FI DOHC
3.2005 HYUNDAI ELANTRA GLS
$5,750 MILEAGE: 77040
ENGINE DESC:2.0L I4 FI DOHC 16V |
|
a*****n
发帖数: 2835 | 40 兄弟们也帮我看一下轮胎选哪个好？需要换两个轮胎，报价是210$
我想用好点的轮胎，
General AltiMAX RT43 (T-Speed Rated) Standard Touring All-Season
Consumer Rating
Warranty Rating
Size: 185/70R14
Sidewall Style: Blackwall
Serv. Desc: 88T
UTQG: 600 A B
Price: $57.00 (each)
Estimated Availability: In Stock
Can be delivered to 02130 on Mon, 04/21 for $12.25 per tire.
Michelin Defender Standard Touring All-Season
Consumer Rating
Warranty Rating
Special Offer:
Buy 4 and get... 阅读全帖 |
|
s***8
发帖数: 1136 | 41 append to orginal desc.
This is substantial change of original desc. The seller should've notified
you about this change of conditions after adding it. So you should have a
good chance to win. |
|
y*********e
发帖数: 518 | 42 输入：{“id”:"id-123","woe_id":[123,456,789],"attribute":{"title":"a","desc
":"b"}}
输出：{
“id”:"id-123",
"woe_id":[123,456,789],
"attribute":{
"title":"a",
"desc":"b"
}
}
要逐层缩进。 |
|
k*******g
发帖数: 26 | 43 我收到很多朋友给我来信希望我推荐他们。我是一个dev，这次却理解recruiter的难处
。我曾经也是找工作的一员，现在工作稳定了，希望帮助同胞。我不牛，我曾经只投了
少于100份简历，但是在50天内得到40多个面试（有些是一家公司多个面试）。可能我
太幸运，但是准备和方法都很重要。
我希望给正在找工作和找人推荐的同学一些建议。
1。了解你要申请的工作。
有些同学连job description都不看，连自己match是否都不完全清楚就申请。看上
去好像是任何机会都争取一下无妨，但是换位思考，如果你是recruiter，你需要在每
天50~1000份简历里面挑选出3~10份来面试，你觉得你被选中的可能性有1%吗？如果你
连job desc都不认真看，你觉得你尊重recruiters和推荐你的人吗？
2。强调你的match和qualifications。
如果你在乎那份工作，你需要研究好它，站在公司的角度想他们需要什么样的（根
据desc推测也好，问别人也好），尽量修改自己简历，凸显自己的qualifications，把
这些都放在最显眼的地方。让recruiters可以... 阅读全帖 |
|
g*l
发帖数: 385 | 44 出现过几次了, 没看见简洁好的解发. 有大侠给个 code? 谢谢.
写出json_pretty的code实现。介绍一下背景，json是一种数据交换格式，基于
JaveScript的。json object就是string key和value的集合。json_pretty就是把一个
一行的json string转换为容易被人阅读的格式。比如：
输入：{“id”:"id-123","woe_id":[123,456,789],"attribute":{"title":"a","desc
":"b"}}
输出：{
“id”:"id-123",
"woe_id":[123,456,789],
"attribute":{
"title":"a",
"desc":"b"
}
}
要逐层缩进。 |
|
x****k
发帖数: 34 | 45 select
scores.score, r
from
scores
join
(
select
score,
rank() over (order by score desc) as r
from (
select
distinct score
from scores
) s
) s1
on scores.score = s1.score
order by scores.score desc; |
|
n*********u
发帖数: 1030 | 46 SELECT state, loan_amount
FROM (
SELECT t1.loan_amount, t1.state, t1.rank, t2.ct
FROM (
SELECT loan_amount, state, (CASE state WHEN @currState THEN @rownum:
= @rownum + 1 ELSE @rownum := 1 AND @currState=state END) + 1 as rank, @
ctnum:=@ctnum+1 ac ct
FROM table t, (SELECT @rownum := 0, @currState := '', @ctnum:=0) r
ORDER BY state, loan_amount DESC
) t1 WHERE t1.rank = t1.ct * 0.1
) tt
order by tt.rank, tt.ct DESC
limit 10; |
|
发帖数: 1 | 47
那我在跳槽前，把现在公司的 job desc 和 skill verification letter 写好让现在
的manager签字不久行了嘛？
另： 1. job desc 和 skill verification letter 可以自己写然后让manager签字吗？
2. 可以不通过manager， 让HR签字吗？
谢谢 |
|
m***y
发帖数: 14763 | 48 It's public records, you can take a look here too.
http://www.norfolkresearch.org/ALIS/WW400R.HTM
For your convenience,
Bk-Pg:19924-566 Recorded: 09-24-2003 @ 1:23:55pm Inst #:
227604 Chg: Y Vfy: Y Sec: N
Pages in document: 3
Grp: 1
Type: Deed Doc$: 2,130,000.00
Desc: LOTS 1&2 PL.BK.442 PL.595
Town: WELLESLEY Addr: 25 HUNDREDS CIRCLE
Gtor: SICCHITANO, KENTON (&AL) (Gtor)
Gtor: SICCHITANO, SUSAN H (&AL) (Gtor)
Gtee: BO, JIEYING (Gtee)
Ref By: 09-24-2003 Homestead In ... 阅读全帖 |
|
|
|
