VIEW MENU

EXAMS

TOP RANK COLLEGES

POPULAR COURSES

POPULAR SPECIALIZATIONS

COLLEGE BY COURSES

COLLEGE BY CITY

Top Medical Colleges In India

Top Medical College



Clear All (X)

State

Andhra Pradesh - (83)
Arunachal Pradesh - (1)
Assam - (12)
Bihar - (13)
Chandigarh - (1)
Chhatishgarh - (5)
Chhattisgarh - (72)
Dadra and Nagar Haveli - (1)
Daman and Diu - (1)
Delhi - (14)
Goa - (3)
Gujarat - (102)
Haryana - (18)
Himachal Pradesh - (20)
Jammu & Kashmir - (11)
Jammu and Kashmir - (8)
Jharkhand - (29)
Karnataka - (386)
Kerala - (84)
Madhya Pradesh - (85)
Maharashtra - (118)
Manipur - (7)
Meghalaya - (3)
Mizoram - (3)
Nagaland - (1)
Odisha - (32)
Pondicherry - (5)
Puduchrry - (6)
Punjab - (56)
Rajasthan - (9)
Tamil Nadu - (7)
Telangana - (1)
Uttar Pradesh - (84)
Uttarakhand - (17)
West Bengal - (4)

Course

select course_id, COUNT(DISTINCT(college_name)) as ttl_course1 from college_approved_data where course_name = ' Bachelor Of Medicine, Bachelor Of Surgery.(MBBS)' AND college_type ='College' AND country_id='101' In aggregated query without GROUP BY, expression #1 of SELECT list contains nonaggregated column 'collegesdirector_collegemaster.college_approved_data.course_id'; this is incompatible with sql_mode=only_full_group_by