-1
I have this Select below:
SELECT b.id,
b.codigo,
a.codacesso,
a.seqproduto,
a.desccompleta,
b.quantidade,
b.data_vencimento,
b.data_atual,
b.observacao,
b.usuario,
b.estado,
b.loja,
a.medvdiageral,
a.comprador,
a.preco
FROM master_datas_b a, master_coletores b
WHERE b.tipo_acao IS NULL
and a.comprador = :comprador
and a.nroempresa = :loja
and b.loja = :loja
and estado = 'Ativo'
and b.codigo = a.codacesso
AND b.data_vencimento BETWEEN TO_DATE(:data1, 'YYYY-MM-DD') AND
TO_DATE(:data2, 'YYYY-MM-DD')
and b.quantidade > 0
ORDER BY b.data_vencimento, b.codigo ASC
He’s returning the values but not the way I need, he’s ordering by day, for example:
12/11/2018
13/12/2018
14/11/2018
I need you to make the order by day and month and December appear only at the bottom of the list..
According to his example the ordination is correct. ASC ordination is increasing, so the date 13/12/2018 really comes after the 12/11/2018.
– George Wurthmann
problem is that it is so 12/11/2018 - 13/12/2018 - 14/11/2018
– Ricardo
I edited your question to add the example of the way you put in the comment.
– George Wurthmann