SQL Server Query Question
- by Lp1
Running SQL Server 2008, and I am definitely a new SQL user.
I have a table that has 4 columns:
EmpNum, User, Action, Updatetime
A user logs into, and out of a system, it is registered in the database. For example, if user1 logs into the system, then out 5 minutes later, a simple query (select * from update) would look like:
EmpNum User …