Need help in SQL Query

[ImBack]

 

SQL Gurus, 

 

In the following link I have posted the input and expected output: 

https://image.ibb.co/kfkOeU/Request.png

The requirement is I want to do groupby of  Children id, Pranetid and snack id

but if the snack id changes in between and shifts to the previous one, then I want SQL to consider it as new group...   Is there any way we can achieve this? 

 

https://ibb.co/c4VZm9

 

Thanks in advance..

[Mitron]

1 hour ago, ImBack said:

 

SQL Gurus, 

 

In the following link I have posted the input and expected output: 

https://image.ibb.co/kfkOeU/Request.png

The requirement is I want to do groupby of  Children id, Pranetid and snack id

but if the snack id changes in between and shifts to the previous one, then I want SQL to consider it as new group...   Is there any way we can achieve this? 

 

https://ibb.co/c4VZm9

 

Thanks in advance..

Bookmark for morning.

[SeenuDumalaHalwa]

 

Select ChildrenId, Parentid, snackid, count(*) from table

group by childrenid,  Parentid, snackid 

If you want to group by output field add output field and use rowid or partition.

 

[ImBack]

2 minutes ago, SeenuDumalaHalwa said:

 

Select ChildrenId, Parentid, snackid, count(*) from table

group by childrenid,  Parentid, snackid 

If you want to group by output field add output field and use rowid or partition.

 

When using rowid or partition it is not recognizing the changes that happened in between..

[ImBack]

CREATE TABLE TEST123( cid VARCHAR(5),
    pid VARCHAR(5),
    sid VARCHAR(5));
    
INSERT INTO TEST123  VALUES ('1','1','a');
INSERT INTO TEST123 VALUES ('1','1','a');
INSERT INTO TEST123 VALUES ('1','1','b');
INSERT INTO TEST123 VALUES ('1','1','b');
INSERT INTO TEST123 VALUES ('1','1','a');
INSERT INTO TEST123 VALUES ('1','1','a');
 

[minimalist]

A bit lazy to explain right now, but try using #views if it rings a bell!

[Aakupaccha_caradu]

[ImBack]

Lift

[Allarinaresh10]

41 minutes ago, ImBack said:

Lift

 

[argadorn]

partition like row preceding by lo cheyachu anukunta ...