当一条sql语句中同时使用DISTINCT和created_at时，可能会出现
ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list错误信息
例如：select DISTINCT id from insure ORDER BY created_at;
翻译意思就是：错误:选择不同,ORDER BY表达式必须出现在选择列表;
意思就是order by 后面跟着的表达式必须出现在select查询列表中
即：select DISTINCT id,created_at from insure ORDER BY created_at
这样就可以了。
当一条sql语句中同时使用DISTINCT和created_at时，可能会出现 ERROR: for SELECT DISTINCT, ORDER BY expressions must appear in select list错误信息 例如：select DISTINCT id from insure ORDER BY created_at; 翻译意思就是：错误:选择不同,O
解决
办法：
sql
server中如果同时用
order
by和
distinct
，那
order
by后面的字段就必须出现在selcet的字段中。这个问题只有在
sql
server中才会有，my
sql
中是不会有这个问题的。
如果这样写会提示错误：
select
distinct
name from user
order
by id
应该这样写：
select
distinct
id,name from us...
Recognition of emotions in facial
expression
s by emotionally disturbed and nondisturbed children
RECOGNITION OF EMOTIONS I N FACIAL
EXPRESSION
S
BY EMOTIONALLY DISTURBED AND
NONDISTURBED CHILDREN
ROBERT H. ZABEL
Kansas State University
Groups of emotionally disturbed and nondisturbed elementary and junior
high subjects were tested for ability to recognize primary emotions in facial
expression
s. Emotionall disturbed groups were found to be significantly less
proficient both for overs
一次在
sql
server 2008 中写
sql
语句：
select
distinct
firstname,lastname from person
order
by person_id
错误提示：
Msg 145, Level 15, State 1, Line 1
ORDER
BY items must
app
ear
in the
select
list
if
SELECT
DISTINCT
...
select
DISTINCT
ON(p.person_id)
p.person_id as personId,
p.person_type as personType,
p.job_number as jobNumber,
p.name,
p.idcard
ORA-01785:
ORDER
BY 项必须是
SELECT
-
list
表达式的数目
ERROR: for
SELECT
DISTINCT
,
ORDER
BY
expression
s must
app
ear
in
select
list
ORA-01785:
ORDER
BY項目は、
SELECT
リスト式の数値である必要があります
错误原因：
ORDER
BY項目里的表达式必须出现在SELEC...
Postgre
SQL
Commands QuickStart：
[url]http://www.thegeekstuff.com/2009/04/15-practical-postgre
sql
-database-adminstration-commands/[/url]
[url]http://www.linuxweblog.com/postgre
sql
-reference[/u...
Expression
#1 of
ORDER
BY clause is not in
SELECT
list
, references column 'xxxx' which is not in
SELECT
list
; this is incompatible with
DISTINCT
问题原因：
my
sql
5.7.5及以上版本将s...
-- =============================================
-- Author: 余波(杭州)
-- Create date: 2011/09/20
-- Descript
