EXAMPLE
Table Dept:
dept_id dept_name dept_status
---------------------------------------
1 Sales 1
2 Develpment 1
3 HR 1
4 QA 0
Table Employee:
emp_id emp_dept_id emp_name emp_sal emp_status
-------------------------------------------------------
1 1 A 10 1
2 2 B 20 0
3 1 C 30 1
4 4 D 40 1
5 1 E 50 0
6 3 F 60 1
7 4 G 70 1
8 2 H 80 1
9 2 I 90 1
10 3 J 100 1
11 4 K 110 1
12 3 L 120 0
13 2 M 130 1
14 1 N 140 1
15 4 O 150 0
16 3 P 160 1
Table JoiningDate
ej_id ej_emp_id ej_joining date
------------------------------------------
1 1 10/05/1997
2 2 14/05/1999
3 3 18/05/2001
4 4 22/05/2003
5 5 26/05/2005
6 6 30/05/2007
7 7 03/06/2009
8 8 07/06/2011
9 9 11/06/2013
10 10 15/06/2015
11 11 19/06/2004
12 12 23/06/2006
13 13 27/06/2002
14 14 01/07/2011
15 15 05/07/2000
16 16 09/07/2004
My Query is:
SELECT * FROM `Dept` DT
JOIN `Employee` EMP ON DT.`dept_id` = EMP.`emp_dept_id`
JOIN `JoiningDate` EJ ON EJ.`ej_emp_id` = EMP.`emp_id`
WHERE
DT.`dept_status` = '1' AND EMP.`emp_status` = '1' ORDER BY Dt.`dept_id`, RAND()
I want result for random two employees from each department.