siva nathan

siva nathan

  • 794
  • 828
  • 235.6k

How to select OT hours from below table?

Mar 20 2017 6:28 AM
 empid    name OThours no of days
 1 s 0 1
 2 n 2 3
I have a table like below i want to select a record like this when working hours >8 means calculate OT
 
 

 

Attachment: Screenshot_(16).rar

Answers (6)