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
- 3043 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 |
What is the difference between unix timestamps and mysql timestamps?
Write a query to display current date and time?
How would you get the current date in mysql?
What are the security alerts while using mysql?
In which format data is stored in mysql database?
What is int mysql?
How many TRIGGERS are allowed in MySql table?
Can mysql function return a table?
How do I connect to mysql database?
How many mysql connections can handle?
How do I setup a mysql database?
How do I delete a row in mysql?
-
Oracle (3259) - 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)
