OpenForum RSS: SELECT distinct contragent .... ORDER BY count(contragent)

SELECT distinct contragent .... ORDER BY count(contragent) (CyberPunk)

Wed, 07 Oct 2009 12:33:25 GMT

>� �� ӣ �� SQL-92 comliant �� :
>SELECT name, count(name) as freq FROM sometable group by name order by
>freq;

��, � � �� "ORDER BY count(name)", �� "AS freq"

�� , ��, ��!

SELECT distinct contragent .... ORDER BY count(contragent) (Warhead Wardick)

Mon, 05 Oct 2009 20:21:23 GMT

>�� : select name, sum(name) from sometable group by name, order by 2

Angra - �� count ��!
�� order by field_num; - �� ^W SQL-92-�� :)

� �� ӣ �� SQL-92 comliant �� :
SELECT name, count(name) as freq FROM sometable group by name order by freq;

SELECT distinct contragent .... ORDER BY count(contragent) (angra)

Sat, 03 Oct 2009 19:31:31 GMT

�� : select name, sum(name) from sometable group by name, order by 2