Mysql query using between

• • Reply

  14 years ago

  by radha_telanakula

  Radha

  , India

  Joined 14 years ago

  empTimeId	empId	companyId	updatedDate	year	weekId	hrsOnSun	hrsOnMon	hrsOnTue	hrsOnWed	hrsOnThu
  8	ppr	mssi	2007-02-23	2007	8	6	7	8	8	12
  10	deepika	mssi1		2007	8		13	10
  11	ppr	mssi	2007-03-01	2007	9		12	9	8	11
  12	deepika	mssi1		2007	9		12	10	13	9
  13	ppr	mssi	2007-03-06	2007	10	8	10
  14	deepika	mssi1		2007	10		12
  15	deepika	mssi1		2007	10		10
  16	deepika	mssi1	2007-03-04	2005	6	2	6	8	9	5
  17	deepika	mssi1	2007-03-04	2005	12	1	1	1	1	1

  
  
  This is my table.
  From this i would like to generate reports.
  Here we are having weekid and  year columns.
  i want to display reports between (year=2005 and weekid=12 )  and (year=2007 and weekid=10);
  
  please give the solution if any one knows.
  
  
  
  
  
  
  
  
  
  Report abuse