>Thanks sir for help.
>Group mean only BATCH not Date
>
>You applied command on where date change
>But I need it on change.
>
>Sir you applied codes on my previous table
>Here is new table which I posted in previous post like this
>
>
>CREATE CURSOR Cetin(id n(2),date t,batch n(4),nSeconds n(6))
>INSERT INTO Cetin values(1,{^2019-02-08 01:25:28 AM},1, 0)
>INSERT INTO Cetin values(2,{^2019-02-08 01:25:29 AM},1, 0)
>INSERT INTO Cetin values(3,{^2019-02-08 01:25:55 AM},1, 0)
>INSERT INTO Cetin values(4,{^2019-02-09 02:28:29 AM},2, 0)
>INSERT INTO Cetin values(5,{^2019-02-09 02:50:18 AM},2, 0)
>INSERT INTO Cetin values(6,{^2019-02-09 08:59:17 PM},2, 0)
>INSERT INTO Cetin values(7,{^2019-02-09 10:25:39 PM},2, 0)
>INSERT INTO Cetin values(8,{^2019-02-12 03:05:19 AM},5, 0)
>>
>I added id and batch field in this.
>
>Please see nSeconds is equal to 0 where new batch comes
>
>
>
>Thans sir
How that is different than the result?
date nSeconds
08/02/2019 01:25:28 0
08/02/2019 01:25:29 1
08/02/2019 01:25:55 26
09/02/2019 02:28:29 0
09/02/2019 02:50:18 1309
09/02/2019 20:59:17 65339
09/02/2019 22:25:39 5182
12/02/2019 03:05:19 0
I have already given solution for this along with a demo link, no?
PS: Why would you name a table "junk" or "Cetin", both are nonsense, aren't they? Why not simply something like "sample" or "test"?
