风水上刀具放置窗台:asp取得唯一值?错在哪里

来源:百度文库 编辑:神马品牌网 时间:2024/05/12 05:32:05
sql="select gongsi_name,max(gongsi_date) from jinding_kehu where renyuan='lily' group by gongsi_name"

在上面为什么无法取得"gongsi_date"的值,怎样才能取得“唯一行”的其他值

SELECT *
FROM Table jinding_kehu
WHERE (NOT EXISTS
(SELECT 1
FROM Table jinding_kehu
WHERE a.gongsi_name = b.gongsi_name AND a.gongsi_date < b.gongsi_date))
ORDER BY gongsi_name"