siva nathan

siva nathan

  • 869
  • 819
  • 217.3k

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)