Generating Sequence Numbers In MS SQL With SPL Code
Need to add sequence number column "Seq" to MS SQL table: increment by 1 for same account within 1hr, reset to 1 after 1hr
A certain table in the MS SQL database has three fields: account, date and time of string type. Now we need to add a sequence number column Seq for the group. When a new event occurs for an account within one hour, Seq+1; If a new event occurs after one hour, reset Seq to 1. SPL code: A1: Use JDBC to query the database, spell out the calculated column DT of date and time type, and sort it by account and DT. A2: Create a new two-dimensional table and add a new calculated column Seq. When the account number of the current record is the same as the previous record and the time interval is with...