Hi, every one
 
the entity modle as follows:
<entity entity-name="Pay" package-name="com.iit.yinshang.order" 
title="Yingshang payment YLCard pay">
  <field name="orderId" type="id-ne" />
  <field name="amount1" type="currency-amount" />
 <field name="amount2" type="currency-amount" />
  <prim-key field="orderId" />
 </entity>
 
how can l get the rocorders by the following sql:
select * from pay order by amount1+amount2 desc
 
Kind Regards
huang zhong zhou

 

Reply via email to