Select problemid AS attribute1,parentid AS attribute2 ,category AS attribute3,requestid AS attribute6 from sd_servicereqmaster sm Inner Join kit_Details kd on kd.sapphire_child_Reqid=sm.requestid Where sm.parentid<>0 AND sm.currentstatus IN (5,60,58,66) and ack_status_api=1 Group by 1 having count(*)>=1 |
120,548
|
376,302
|
68,548
|
|
0.00
|