Interested to Buy Any Domain ? << Click Here >> for more details...
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..
- 1 Answers
- 3071 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
Explain triggers and stored procedures?
How can you plan the logshipping before processing?
What are the purposes of using enum and set data types?
What is the current root password of mysql?
What is data types in mysql?
How to create table with same structure of student table in mysql?
In how many ways we can retrieve the data in the result set of MySQL using PHP? What is the difference between mysql_fetch_object and mysql_fetch_array ?
Is mysql owned by oracle?
What is difference between statement and preparedstatement?
What are the other commands to know the structure of a table using mysql commands except explain command?
How do I fix a crashed mysql database?
What is trigger in mysql with example?
What is mysqli_select_db?
How to increment dates by 1 in mysql?
What is row?
