Its a general group by Error.

Solution for this error

Hi..

I am not understand what you want to say..

Can u share your sql script.

Hi.

Sql Script : SELECT SUBJECT, ID,NAME FROM STUDENTS GROUP BY SUBJECT

In the above script you are using GROUP BY clause. From Sql concept if u r using GROUP BY clause then u have to using any aggregate function like sum,avg..etc.

i think your above query like this
SELECT ID,NAME,sum(MARKS) FROM STUDENTS GROUP BY Name

Please give me replay..if u want something more..

post ur sql script
i will resolve ur problem

For using group by clause we have to use aggregate function.

Dhiru