clear markdown compare help donate or buy diddy dollings comments/suggestions/bugs a leap of faith? bible365
clear markdown donate comments/suggestions/bugs a leap of faith? bible365 diddy dollings
By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0. 818545 fiddles created (9195 in the last week).

create table sidewalk_deficiency ( def_id number(10), insp_id number(10), def_length number(10,2));
 hidden batch(es)


insert into sidewalk_deficiency values (10,1,.5);
1 rows affected
 hidden batch(es)


insert into sidewalk_deficiency values (11,1,1);
1 rows affected
 hidden batch(es)


insert into sidewalk_deficiency values (12,1,1.5);
1 rows affected
 hidden batch(es)


insert into sidewalk_deficiency values (13,2,2);
1 rows affected
 hidden batch(es)


insert into sidewalk_deficiency values (14,2,2.5);
1 rows affected
 hidden batch(es)


select insp_id, def_length from sidewalk_deficiency group by insp_id, def_length
INSP_ID DEF_LENGTH
2 2.5
1 .5
1 1
2 2
1 1.5
 hidden batch(es)


insert into sidewalk_deficiency values (14,2,2.5);
1 rows affected
 hidden batch(es)


select insp_id, def_length, sum(def_length) as sm from sidewalk_deficiency sd group by insp_id, def_length
INSP_ID DEF_LENGTH SM
2 2.5 5
1 .5 .5
1 1 1
2 2 2
1 1.5 1.5
 hidden batch(es)