r3nder
asked on
getting a start date and end date from different rows MySQL
I have a query, in that query I get the start time and a toolnumber
And make this:(start date is the first date and the enddate is the firstdate of the next record with a new tool number
DROP TABLE IF EXISTS precont;
CREATE TABLE precont AS (
SELECT UploadTime as 'StartTime', ToolNumber
FROM ToolAssemblies
WHERE ControllerSn = 1024);
What I want is to take this:(the query above)And make this:(start date is the first date and the enddate is the firstdate of the next record with a new tool number
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER