Q. Give commission of Rs. 500 to all employees who joined in year 1982 (table Empl).
Table ---
Answer =
Update Empl
Set comm = comm + 500
Where hiredate between “1982-01-01” and “1982-12-31” ;
Table ---
Answer =
Update Empl
Set comm = comm + 500
Where hiredate between “1982-01-01” and “1982-12-31” ;
Update Empl Set comm=comm+500 where year(hiredate)=1982;
ReplyDeleteIs it correct??
No, formate of writting date (1982) is wrong.
Deletepaathwala is wrong ... the above mentioned command by the person is also correct......i have checked with the MYSQL
DeleteNo i think because date format in sql is YYYY-MM-DD
ReplyDelete👍
Deleteupdate empl
ReplyDeleteset comm=comm+500
where hiredate of empl=1982
is it correct??
No, Date is not in date formate.
DeleteWhere date>=1982-01-01
ReplyDeleteIs correct
No, your query will also include year > 1982.
DeleteCan it be like Update Empl
ReplyDeleteSet comm = comm + 500
Where hiredate like "1989%";
yea its correct
DeletePost a Comment
You can help us by Clicking on ads. ^_^
Please do not send spam comment : )