我如何转换此sql代码，以便MS Access能够理解它? [英] How do i convert this sql CODE so that MS Access understands it?

问题描述

我有一个包括SQL和MS Access在内的家庭作业，我一直在努力弄清楚，但不能..我只是收到一条错误消息..我的代码用于视图..

I've got a homework that includes SQL with MS Access I've been trying hard to figure it out but could'nt.. Im just getting an error message.. My code is for a view..

这是代码:

(SELECT Rum, COUNT(DISTINCT(Larare)) AS antal FROM Kurstillfalle
GROUP BY Rum)

推荐答案

访问不支持COUNT(DISTINCT列名)，但是您可以这样做:

Access does not support COUNT(DISTINCT columnname) but you can do this:

SELECT 
  t.Rum, 
  COUNT(t.Larare)) AS antal 
FROM (SELECT DISTINCT Rum, Larare FROM Kurstillfalle) AS t 
GROUP BY t.Rum

这篇关于我如何转换此sql代码，以便MS Access能够理解它?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！