5
I would like to create a SELECT
with the personal relationship here of my company.
SELECT função, nome FROM responsavel;
So far so good. But as ordered by the Manager, passing by the Incumbent, Supervisor until General Services Assistant, in this order?
THAT IS TO SAY:
GERENTE, FULANO;
ENCARREGADO, CICLANO;
SUPERVISOR, BETÂNIO;
AUX. DE SERV. GERAIS, REGÂNIO;
In this order.
Possible duplicate of Order By - Leave specific record for first
– Roberto de Campos
@Robertodecampos, I do not think it is a duplicate saw, it seems what he wants is something like an Ordination according to a hierarchy of the company, as if, the "Manager" was more important and came first, then "In Charge". In the other case of the link, the guy wanted only the city "Boston" to be in first. At least that’s what I understood, and if he was going to use the same idea as the link response, I guess I would have to do
!=
for everyone, it would be weird. But this is what I think kkk– Richard Willian
I edited my answer, I believe that now this in agreement :)
– Wictor Chaves
You’re right @Richardwillian, I’ll take my vote as duplicate.
– Roberto de Campos