var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: howto get at max 2 employee fron each table?
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
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...
and the silly thing is , this is not even ms-access forum .
Tags for this Thread