sql - 对从 postgresql 中的查询获得的值进行排序

Question

select SUM (Account_Invoice.amount_untaxed),
       right (Res_Partner.vat,length(Res_Partner.vat)-2) as RFC 
from Account_Invoice inner join Res_Partner on Account_Invoice.partner_id = Res_Partner.id 
     inner join Account_Invoice_Tax on Account_Invoice.id = Account_Invoice_Tax.invoice_id 
where account_invoice.journal_id=2
      and account_invoice.date_invoice >= '2013-01-01' 
      and account_invoice.date_invoice <= '2013-02-01'
      and account_invoice.reconciled is TRUE 
      and account_invoice_tax.account_id = 3237 and account_invoice.amount_tax >= 0
      or account_invoice_tax.account_id = 3236 or account_invoice_tax.account_id = 3238

我希望对 3236 的免税金额进行排序，然后是 3237 的金额，最后是 3238 的金额。我知道我必须使用“分组依据”，但我不明白具体如何操作。有什么指点吗？

Answer 1

这对我有用，它将值从 3236 排序，然后是 3237，然后是 3238。

select SUM(Account_Invoice.amount_untaxed) as monto, 
right (Res_Partner.vat,length(Res_Partner.vat)-2) as RFC
from Account_Invoice 
inner join Res_Partner on Account_Invoice.partner_id = Res_Partner.id 
inner join Account_Invoice_Tax on Account_Invoice.id = Account_Invoice_Tax.invoice_id 
where account_invoice.journal_id=2 
and account_invoice.date_invoice >= '2013-01-01' 
and account_invoice.date_invoice <= '2013-02-01' 
and account_invoice.reconciled is TRUE 
and account_invoice_tax.account_id in (3237,3236,3238)
and account_invoice.amount_tax >= 0
GROUP BY vat,account_invoice_tax.account_id
ORDER BY account_invoice_tax.account_id;

谢谢大家的帮助。