Zbytečně komplikovaný dotaz? – MySQL – Fórum – Programujte.com

Není to sice MySQL, ale... budiž. Učím se trochu dělat v PowerBuilderu a v tutoriálu jsem narazil na tento dotaz:

DECLARE custstatecursor CURSOR FOR

SELECT state FROM customer

GROUP BY state HAVING count(state)=1

UNION

SELECT state FROM customer

GROUP BY state

HAVING count(state)>1;

DECLARE custstatecursor CURSOR FOR

SELECT state FROM customer

GROUP BY state;

ono by asi slo pouzit i select distinct(state) from customer