sql1

Sql code posted
created at 16 Jun 17:15

Edit | Back 
1
 
select dc.msisdn, COUNT(dc.was_successful) from delivery_confirmation dc, campaign c where c.id = dc.campaign_id AND dc.campaign_id = 153 group by dc.msisdn having COUNT(dc.was_successful) = max(c.sat_message_packet_count)
222 Bytes in 1 ms with coderay