🚀 go-pugleaf

��Ĵ��벻����һ��̫�ֲ��ˡ�����
��������һ�£�
select * from (
select top(99.99) percent from 
(select * from table where ... )t1)  
order by a desc, b desc) t2 
union all  
select * from (select top(99.99) percent from 
(select * from table where ... )t3)  
order by a desc, b desc) t4 
union all  
select * from (select top(99.99) percent from 
(select * from table where ... )t5)  
order by a desc, b desc) t6

������û������ΪʲôҪ��top 99.99
�� �� Goliath (Schumi) �Ĵ������ᵽ: ��
: ����������a,b(��Ϊ��ֵ��),Ҫ��õ��Ľ���Ϊ���,��һ������a>20 and b>20��
: ����,�ڶ�������(a>20 and b<=20) or (a<=20 and b>20)�IJ���,�������a<=20 an
: d b<=20�IJ���,��ָ��Ը��a desc, b desc�ķ������,����Ӧ����ν��.
: ����������union all�İ취���,�����Ӳ�ѯ����ֱ������,��ʹ�õ���top���,��sel
: ect * from (select top(99.99) percent from (select * from table where ... )t
: 1)  order by a desc, b desc) t2 union all  select * from (select top(99.99) 
: percent from (select * from table where ... )t3)  order by a desc, b desc) t
: 4 union all  select * from (select top(99.99) percent from (select * from ta
: ble where ... )t5)  order by a desc, b desc) t6
: ����top()percent ������ʹ��100%����û������ʲô�취���Դﵽ���Ŀ��?


--
I thought what I'd do was, I'd pretend I was one of those deaf-mutes
Or should I?

You know what I��d like to be? I mean if I had my goddam choice, I��d just be
the catcher in the rye and all.

�� ��Դ:����ˮ˼Դ bbs.sjtu.edu.cn��[FROM: 207.46.55.30]