How to do this Query

Posted in 1997

"S.Sathish" — 28 Oct 1997 03:13:24 -0500 — source: Informix-list mailing list archive (1991-1998)

Hi, Table : Dept_id Emp_id I want the dept_id which has Nth maximum number of employees. Eg: 1st maximum no of employees ie,..,the dept_id which has the max no of employees. 2nd max no of employees ie,..,the dept_id which is second in the list of no of employees in a dept .......... So, i want a general method for the Nth case. ****************************************************************************** S.Sathish email :ssathish@cmcbang.ernet.in ******************************************************************************