Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have

Hi!
I’m doing one Project in vb.net 2008 using mysql .In that
Project have the following Issues..
1.if one Employee getting Salary 1.2 lacs / annum means ..
After he getting 1st month Salary i want to show remaining
11 month salary.. How can i Create Trigger for this Problem
& How can i use it..

Question Posted / uma.btechinfotech

1 Answers
2798 Views
I also Faced
E-Mail Answers

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues..

Answer / ram gopal verma

select * from employee where empdate BETWEEN DATE_FORMAT(NOW(), '%Y-01-%d') AND DATE_FORMAT(NOW() ,'%Y-05-%d')

Note- I u want (%Y-01-%d) means show February month to (%Y-05-%d) June months.

Is This Answer Correct ?

1 Yes

0 No

Post New Answer