I have a table in my Database which contains the punch time of Employee, I want to update the reader mode column of the
table with the values (I or O) according to the swipe_datetime of the Employee.
the issue is that the when the first swipe_datetime of the employee should be considered as reader_mode I
while the next should be considered as O
I am attaching a sample data along with this so that you can provide me the correct sql query.
I hope I will get the answer very soon.
Thanks in Advance for the help.