Sql query

[sarah_chandran]

If table1 has fields Studentname , departmentid and table2 has fields departmentid,departmentname then can anyone give me the sql query to get the department name and the number of students in each department.

[Wendelius]

Sounds like homework. Simply join and fetch the data from both tables and then group by department name. Use COUNT to calculate the amount of students.

The need to optimize rises from a bad design.My articles[^]

[Vimalsoft Pty Ltd]

Try this

SELECT Studentname , departmentid
FROM TABLE1 T1 INNER JOIN TABLE2 T2 ON
T1.departmentid = T2.departmentid
ORDER BY departmentid

Hope it helps

Vuyiswa Maseko, Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers." C#/VB.NET/ASP.NET/SQL7/2000/2005/2008 http://www.vuyiswamaseko.tiyaneProperties.co.za vuyiswam@its.co.za

[ChandraRam]

Vuyiswa Maseko wrote:

Try this SELECT Studentname , departmentid FROM TABLE1 T1 INNER JOIN TABLE2 T2 ON T1.departmentid = T2.departmentid ORDER BY departmentid

The OP wants department name and count of students - your query returns neither. ;P

[sarah_chandran]

Thank u , just what I needed. select deptname,COUNT(deptid) from emp,department where emp.deptid =department.id group by deptname