����ؿ��λ���

¾��¿�����䤤��碌����Τ褦�ˡ� PostgreSQL�� ����ؿ��򥵥ݡ��Ȥ��ޤ��� Postgres �ν���ؿ��θ��ߤμ����ˤ� �����Ĥ������󤬤���ޤ��� �äˡ����󥹥��󥹤ν���ؤ� count, sum, avg (ʿ��), max (�ǹ�), min (�Ǿ�) �ʤɤη׻��򤹤뽸��ؿ�������ޤ����� ����ؿ����䤤��碌�Υ������åȥꥹ�ȤˤΤ߻Ȥ����Ȥ��Ǥ��ޤ����� �����(where��)��ľ�ܻȤ����ȤϤǤ��ޤ��� ��Ȥ��ơ�

SELECT max(���㵤��) FROM ŷ��;

SELECT �� FROM ŷ�� WHERE ���㵤�� = max(���㵤��);

SELECT �� FROM ŷ�� WHERE ���㵤�� = (SELECT max(���㵤��) FROM ŷ��);

����ؿ��Ϥޤ�group by�����Ĥ��Ȥ��Ǥ��ޤ�:

SELECT ��, max(���㵤��)
    FROM ŷ��
    GROUP BY ��;