Gcobani Mkontwana

Gcobani Mkontwana

  • 1k
  • 1.4k
  • 192.8k

How to calculate totalActivity and lastActivity?

Oct 13 2020 5:16 AM
Hi Team
 
I need some help, i have these two fields and want to filter their data types, but need some help as to how to work this out in sql server. Meaning TotalActivity must this format as output and LastActivity.
  1. Oct 13 at 3:41am  
  2. 21:02:04 // Must always counts when a user logs in and out  
 

Answers (3)