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
- 3194 Views
- I also Faced
- E-Mail Answers
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 |
Why do we use group by and order by function in mysql?
How important is to list the column names when doing an insert?
Why does mysql have so many connections?
Can we save images in mysql database?
Write command to import an mysql file?
How to show certain selected rows with the value "pcds".
What is the difference between timestamp and datetime in mysql?
How does mysql store binary data?
How to give user privilages for a db. Login as root. Switch to the mysql db. Grant privs. Update privs.
How to Set a root password if there is on root password.
Does mysql case matter?
How to enter Characters as HEX Numbers?
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
