Question

关于数据库不是单组分组函数的问题，求人帮忙啊！！

select ct_ywbh,ct_wzbm,am_dj from wzn_lld_d where ct_wzbm ='0104020101040001' order by ct_ywbh;
查询结果有3条数据，想取ct_ywbh 最大的一条数据的am_dj 字段的值，怎么写语句。

Answer 1

select am_dj from wzn_lld_d where ct_ywbh = (select top 1 ct_ywbh from wzn_lld_d where ct_wzbm ='0104020101040001' order by ct_ywbh desc )

追问

ora -00923 未找到要求的from 关键字。

Answer 2

select top 1 am_dj from wzn_lld_d where ct_wzbm ='0104020101040001' order by ct_ywbh desc