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
3046 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

Explain what is mysql?

982

What are the three types of queries?

851

Does mysql support sequence?

884

What is the maximum size of table in mysql?

958

How do I insert an image into mysql workbench?

899

How do I rename a table in mysql workbench?

906

How to get a list of all tables in a database?

1002

What are the types of database engines available in mysql?

953

how you will show all records not containing the name "sonia" and the phone number '9876543210' order by the phone_number field.

860

Is mysql free download?

811

How to returns the columns and column information pertaining to the designated table.

975

What is session variable in mysql?

911

How to load data files into tables with 'mysqlimport'?

923

What is orm in mysql?

852

What is the limitation of mysql?

908