Clase 1, Viernes, 02 de Diciembre de 2011

Repaso de sentencias SQL

Ejemplos, SELECT:


select cargo, count(numempleado) as cantidad
from empleado
group by cargo
having count(*) >= 5

select cargo, count(numempleado) as cantidad from empleado group by cargo order by count(*) desc
select cargo, count(numempleado) as cantidad from empleado group by cargo order by cargo desc
select * from empleado where lower(sexo) = 'f'


select
cargo, count(numempleado) as cantidad from empleado group by cargo order by cargo desc
　
select
cargo, count(numempleado) as cantidad from
empleado
where
lower(sexo) = 'f' and lower(cargo) = 'asistente' group
by cargo
　
select
ciudad, count(*) as "Numero de oficinas"
from
oficina
group
by ciudad