Hi all,
mysql db :
create table students (
id int primary key,
name varchar(50),
birtdate date,
city varchar(50),
year int,
faculty varchar(50),
depcode int,
depname varchar(50))
-- in which department (depname) there is the highest amount of students
the result should return the deptname and the amount .
-- Note cannot use analytic function / order by limit for solution.
please your help.
Thanks in Advanced