生完宝宝多久可以健身:asp取得唯一值?错在哪里

来源:百度文库 编辑:高考问答 时间:2024/05/03 07:40:31
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"