| Subject | Re: [firebird-support] order by 1, 2 - fb 32990 |
|---|---|
| Author | Helen Borrie |
| Post date | 2018-04-13T05:29:11Z |
acgomes2001@... wrote:
not make any sense to ORDER BY 2 (nor ORDER BY 1,2) as your literal
field FORMA_PAGTO has the same value in every row. So:
select
A.Codigo, /* <<-------- */
'DINHEIRO' FORMA_PAGTO
FROM NF A
where A.dataEmissao between '01.01.2018' and '31.01.2018'
and A.Modelo = '55'
order by 1
HB
> selectThis should work fine if you place a comma after A.Codigo. It does
> A.Codigo
> 'DINHEIRO' FORMA_PAGTO
> FROM NF A
> where A.dataEmissao between '01.01.2018' and '31.01.2018'
> and A.Modelo = '55'
not make any sense to ORDER BY 2 (nor ORDER BY 1,2) as your literal
field FORMA_PAGTO has the same value in every row. So:
select
A.Codigo, /* <<-------- */
'DINHEIRO' FORMA_PAGTO
FROM NF A
where A.dataEmissao between '01.01.2018' and '31.01.2018'
and A.Modelo = '55'
order by 1
HB