[redes] Re: Fwd: sql
- From: Luana Meurer <luameu@xxxxxxxxx>
- To: grupo de e-mail faculdade <redes@xxxxxxxxxxxxx>
- Date: Thu, 24 Oct 2013 12:11:07 -0200
\o
mt eficiente
Atenciosamente,
Luana Meurer
2013/10/24 Gustavo O Ph <gustavoph80@xxxxxxxxx>
> /* 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:
