I've created a table called :FACULTY
It has the following details --
FacultyCode : Not null, Primary key, Starts with ‘F’
FacultyName : Not null
DateOfJoin : Not null
DeptCode: Must be either CSE,IT, CA, CHEM, MTHS, PHYS, HUM, BBA
Another table that I've created is :DEPARTMENT
It has following details --
DeptCode: Not null, Primary key
DeptName: Not null
HOD : Foreign key references FacultyCode of table FACULTY
Then I've inserted appropriate data into these 2 tables. Now the question is "Name the departments having highest number of faculties and display the names of faculties" . How to solve this in SQL queries ?
2006-10-24
20:29:16
·
3 answers
·
asked by
Innocence Redefined
5