Studio ODIN

ORDER BY expressions must appear in select list

���̂悤�� PostgreSQL �� SQL �G���[������܂��B

SELECT DISTINCT, ORDER BY expressions must appear in select list

����� SELECT DISTINCT ���g�p���Ă���ꍇ�ɁA ORDER BY ��Ɋ܂܂�Ă��鍀�ڂ� SELECT ��ɂȂ��ꍇ�ɔ������܂��B

�Ⴆ�΁A���̂悤�� SQL �ł��B

SELECT DISTINCT
       field_1
     , field_2
FROM test_table
ORDER BY field_3

SELECT DISTINCT ����Ă���̂� field_1 �� field_2 �ł��� �\�[�g�� field_3 ���w�肵�Ă��܂��B

����ł͌��ʂ̕��я���ۏ؂��邱�Ƃ��ł��Ȃ����� �G���[����������킯�ł��B

���Ȃ݂� Oracle �̏ꍇ�́A���̂悤�ȃG���[�ɂȂ�܂��B

ORA-01791: SELECT���������ł�

�����AOracle �� ����Ɍ����悤�ŁA���̂悤�ȏꍇ�̓G���[�ɂȂ�܂���B �i PostgreSQL �̓G���[�ɂȂ�܂��j

SELECT DISTINCT
       field_1
     , field_2
FROM test_table
WHERE field_3 = '0'
ORDER BY field_3

���̏ꍇ�́Afield_3 �� 1�‚ɌŒ肳��邽�߁A "�\�[�g�w��Ȃ�" �Ɠ�����ԂɂȂ邽�߃G���[�ɂȂ�܂���B