select * from employee where empdate BETWEEN DATE

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 / ram gopal verma

1 Answers
3127 Views
I also Faced
E-Mail Answers

Answer Posted / 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 View All Answers

Please Help Members By Posting Answers For Below Questions

What is save point in mysql?

960

How to connect html form to mysql database using php?

950

Do while loop in mysql procedure?

1077

Does mysql use sql?

897

What are the 5 r's of managing behaviors?

1089

In mysql, what is the default storage engine?

1010

What is the use of mysql workbench?

1017

How can you move the master database

2049

What happens if null values are involved in expressions?

1034

What is the maximum no of columns a table can have?

913

How can you count the total number of records of any table?

924

How to calculate expressions with sql statements?

1120

how to search second maximum(second highest) salary value(integer)from table employee (field salary)in the manner so that mysql gets less load?

887

What is dblink?

897

How do I add a column to a table in mysql?

917