🚀 go-pugleaf

��ȥ��ϸ�����£���ʵ��������򻯵�һ��sql������棬
������ʾ��

select * from tabnam where �˳�ԭ��='F0' and 
(�˳�����,�˳�ʱ��) in (select �˳�����,max(�˳�ʱ��)
from tabnam group by �˳�����)
union
select * from tabnam where (�˳�ԭ��='DSC20' 
or �˳�ԭ��='DSC21') and (�˳�����,�˳�ʱ��) in 
(select �˳�����,max(�˳�ʱ��) from tabnam where 
(�˳�ԭ��='DSC20' or �˳�ԭ��='DSC21') group by
�˳�����)
union
select * from tabnam where �˳�ԭ��='P0' and
(�˳�����,�˳�ʱ��) in (select �˳�����,max(�˳�ʱ��)
from tabnam where �˳�ԭ��='P0') and �˳����� not in
(select distinct �˳����� where �˳�ԭ��='F0')


�� �� hermit (�����ޡ���ӵ�Ұ�) �Ĵ������ᵽ: ��
: ��������ش𣬹ؼ���union��ʹ�ã��������sql��ִ�п϶��첻��
: on error resume next
: rsdat.open "select distinct �˳����� from tabnam order by �˳�����" , _
:            yourconnection, adOpenStatic, adLockOptimistic
: do while not rsdat.eof
:    thedat=rsdat.fields(0).value
:    rsinf.open "select * from tabnam where �˳�����=#"+thedat+"# and _
:                �˳�ԭ��='F0' and  _
:                �˳�ʱ��=( select max(�˳�ʱ��) from tabnam where _
:                �˳�����=#"+thedat+"#  _
:                and �˳�ԭ��='F0') union _
: ...................

--

�� ��Դ:��BBS ˮľ�廪վ smth.org��[FROM: 218.244.235.163]