Ok, so I have a table on an MySQL server, it has the following columns: Key, UserID, datetime and position Position can be "start", "login" and "end". I want to find out the difference between start, sign in and end for each login event. Anyone have an idea of an SQL query I could use? I think it has something to do with a query within a query?
Query Question
Query Question
Query Question
Ok, so I have a table on an MySQL server, it has the following columns: Key, UserID, datetime and position Position can be "start", "login" and "end". I want to find out the difference between start, sign in and end for each login event. Anyone have an idea of an SQL query I could use? I think it has something to do with a query within a query?