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
- 3108 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
How set mysql root password?
What is mysql and why it is used?
What are programming functions?
why not null is not allowed at table level
What are the differences between innodb and myisam engines?
What happens when the column is set to AUTO INCREMENT and if you reach maximum value in the table?
How to delete the repeated records from a table?
Why we use mysql workbench?
Can you rename a database in mysql?
I want to insert userid of a customer,order time,etc in a table called ordermaster with orderid as primary key.Same time the product codes and required quantities (a1,2 and a2 4 and so on)inserted in another table orderdetails with same orderid reference.How the code will be in JSP using MySQL?
How do I rename a mysql database?
What is dbms in mysql?
Why do we use views instead of tables?
Can you tell the difference between $message and $$message?
What is default schema in mysql?
