Al-Qaeda's No. 2 killed in US drone attack in Pakistan