|
-
 Originally Posted by Sivak
Start time and end time is stored seperately in two different records and I would need to calculate time difference. Shipment_Id values identifies relation between records.
QUestion is,
I need to know SQL statement to generate this result. Can you give me a sample SQL.
Write the query without the lead/lag, is the row that you are looking for immediately preceding or following the row that you are comparing to? Is the offset always the same? According to the links you need to know the row offset.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote