select code,max(LONGDESCRIPTION) from currency group by code
得到如下
但是我外部再套一层select如下:
select * from
(
select code,max(LONGDESCRIPTION) from currency group by code
) currency
where 2='美元';
这样查报错啊
...全文
10961打赏收藏
求大神解答,max()后面不用as,会默认按照列的顺序生成字段名,但是我要怎么查呢
select code,max(LONGDESCRIPTION) from currency group by code 得到如下 但是我外部再套一层select如下: select * from ( select code,max(LONGDESCRIPTION) from currency group by code ) currency where 2='美元'; 这样查报错啊