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
- 3052 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 |
Which is faster mysql or mongodb?
How to get last inserted id after insert data from a table in mysql?
How do you start and stop MySQL on Windows?
How can I see mysql database?
Which is better sqlite or mysql?
How do I install mysql on windows 10 64 bit?
What is normalization and list the different types of normalization?
Is blocked because of many connection errors mysql?
What are the types of database engines available in mysql?
What is difference between mysqli and pdo?
How can I create database in mysql?
What is mysql root?
-
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)
