云服务器需要备案:asp取得唯一值?错在哪里

来源:百度文库 编辑:查人人中国名人网 时间:2024/05/12 04:00:37
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"