Question

SQL MAX()函数问题

请问: 以下代码错在哪？
<%
Dim Recordset1
Dim Recordset1_numRows

Set Recordset1 = Server.CreateObject("ADODB.Recordset")
Recordset1.ActiveConnection = MM_myconn_STRING
Recordset1.Source = "SELECT d_id ,d_BirthDay_year, d_sex, d_workingyrs,d_address_now_province, d_address_now_city, e_major, e_major2,max(e_diploma) as e_diploma FROM dbo.Data_Education group by d_id WHERE d_sex = '" + Replace(Recordset1__MMColParam, "'", "''") + "' AND d_zhineng1_2='" + Replace(Recordset1__bbc, "'", "''") + "'"
Recordset1.CursorType = 0
Recordset1.CursorLocation = 2
Recordset1.LockType = 1
Recordset1.Open()

Recordset1_numRows = 0
%>

Answer 1

sql语句有问题：
改为group by d_id ,d_BirthDay_year, d_sex, d_workingyrs,d_address_now_province, d_address_now_city, e_major, e_major2 才对
建议看sql基础

Answer 2

sql语句貌似没错，问题太模糊。