Doubt in SQL query with Group by and Order by

Question

Good afternoon Galera!!!

I have an sql query that is simple, but I’m having a hard time doing an order by in two fields at once. Such consultation is for me to assemble a report, but before mounting I need to validate this query. The query being performed is this:

select 
   cped.razsocial,
   cped.nrpedido,
   iped.codbarra,
   iped.codprod,
   iped.qtde,
   iped.descricao,
   funcionario.fantasia,
   cped.dtpedido,
   produto.observacao,
   cped.liberado,
   cped.statusweb
from cped

inner join iped on (cped.nrpedido = iped.nrpedido)
inner join produto on (iped.codprod = produto.codprod)
inner join funcionario on (cped.indicacao = funcionario.funcionario)
inner join almox on (cped.almoxarifado = almox.codigo )

where (
  (cped.tipo = 'Z') )


group by 
  cped.razsocial,
  cped.nrpedido,
  iped.codbarra,
  iped.codprod,
  iped.qtde,
  iped.descricao,
  funcionario.fantasia,
  cped.dtpedido,
  produto.observacao,
  cped.liberado,
  cped.statusweb

order by iped.descricao,cped.nrpedido

When executing the command works, however it only orders by iped.descricao. I need it to be sorted by description but the cped.nrpedido field is attached, that is, if the customer has 3 items within the order with descriptions of different items, that he does not throw the request at the end of the list, but leave grouped.

Thanks in advance.

Answer 1

TL;DR;

If I correctly inferred your model, to get the desired result your order by it must be so:

order by cped.razsocial, cped.nrpedido, iped.descricao

Explaining

You don’t order by two fields at the same time. You order one field and then another.

I think you have confused the concept of ordering a little bit. Look, assuming the following data set:

joão  | banana  | 1
joão  | maçã    | 1
maria | banana  | 2
maria | banana  | 3
maria | maça    | 3
maria | banana  | 4
joão  | maçã    | 5
joão  | acerola | 5
maria | acerola | 6

According to your consultation, the result of the sorting for this data set would be thus:

joão  | acerola | 5
maria | acerola | 6
joão  | banana  | 1
maria | banana  | 2
maria | banana  | 3
maria | banana  | 4
joão  | maçã    | 1
maria | maça    | 3
joão  | maçã    | 5

That is, it is ordered by description of items and next for order number. First they’re all gonna show up with their orders and then they’re gonna show up with the bananas and then they’re gonna list the apples. Regardless of what order these items were made.

By his text, his expectation would be that result:

joão  | banana  | 1
joão  | maçã    | 1
joão  | maçã    | 5
joão  | acerola | 5
maria | banana  | 2
maria | banana  | 3
maria | maça    | 3
maria | banana  | 4
maria | acerola | 6

In other words: Ordained by client, next for request and next for item description.

I hope I’ve helped.