Hello Sir,
I need a SQL query in whichi want to select N number of employee from table Training_emp such that
----> There are at max 2 emp from any department

MyTableStructure is:
Training_emp:
Emp_code
Topic
Session
Month
Inn_add
Attend
Date

Emp_master:
Emp_code
DeptName

now what i want is..to select say 20 employees from Training_emp table....
suct that no more that two employeees from same departnment are selected.
My frontend is VB and back end is MS access

what a coincidence, somebody else posted an almost identical question in a different forum...

How to get at max 2 employee from each department?

and the silly thing is , this is not even ms-access forum .