Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

django锟斤拷distinct锟斤拷order by

4 views
Skip to first unread message

���ӳ����~

unread,
Jun 19, 2014, 11:30:59 AM6/19/14
to
锟斤拷锟斤拷同一锟斤拷column锟侥伙拷锟斤拷锟斤拷锟斤拷锟睫斤拷锟剿ｏ拷

锟斤拷锟斤拷锟揭碉拷table锟斤拷size锟斤拷name锟斤拷锟斤拷锟斤拷要order by size锟斤拷锟斤拷锟斤拷锟斤拷要name distinct锟斤拷table.objects.all().distinct('name').order_by('size') 锟较讹拷锟斤拷锟斤拷

锟斤拷锟斤拷锟斤拷锟斤拷啥效锟绞的憋拷通锟斤拷锟斤拷锟斤拷
--

[m [32m锟斤拷 锟斤拷源:锟斤拷水木锟斤拷锟斤拷 http://m.newsmth.net锟斤拷[FROM: 49.77.244.*] [m

sud

unread,
Jun 19, 2014, 11:45:18 AM6/19/14
to
���Ȱ�����������
���� select distinct on (name) * from t order by size
distinct��order byǰ��ִ�к��ں���ִ�� �᷵�ز�ͬ�Ľ��
�� �� perf (���ӳ����~) �Ĵ������ᵽ: ��
: ����ͬһ��column�Ļ��������޽��ˣ�
: �����ҵ�table��size��name������Ҫorder by size��������Ҫname distinct��table.objects.all().distinct('name').order_by('size') �϶�����
: ��������ɶЧ�ʵı�ͨ������

--

[m [35m�� ��Դ:��ˮľ���� http://newsmth.net��[FROM: 124.207.43.*] [m
0 new messages