[redes] Fwd: sql
- From: Gustavo O Ph <gustavoph80@xxxxxxxxx>
- To: redes@xxxxxxxxxxxxx
- Date: Thu, 24 Oct 2013 11:39:45 -0200
/* select count (*) AS TOTAL
from almmaterial almt */
/* select vtc.sexo_cliente as sexo,
vtc.nome_cc
from vtcentro_custo vtc
where vtc.sexo_cliente = 'F' */
/* select count(vtc.sexo_cliente)
from vtcentro_custo vtc
where vtc.sexo_cliente = 'M' */
/* select count(*)
from veiculo */
select vtc.razao_social
from vtcentro_custo vtc
where vtc.razao_social like 'Agropecuária%'
---------- Forwarded message ----------
From: Gustavo O Ph <gopwh0@xxxxxxxxx>
Date: 2013/10/24
Subject: sql
To: Gustavo O Ph <gustavoph80@xxxxxxxxx>
/* select gfo.cod_fornecedor AS cfor,
substring(gfo.nome_fornecedor from 3 for 10) AS nfor
from gerfornecedor gfo
where gfo.cod_fornecedor between 12 and 14 */
---------------------------------------------------------------------
select avg(me.custo_medio) AS AVG
max(me.custo_medio) AS MAX
min(me.custo_medio) AS MIN
from movto_estoque me
Other related posts:
