Blog entry by 97213529 郭益銘

รูปภาพของ97213529 郭益銘
โดย 97213529 郭益銘 - อังคาร, 2 ธันวาคม 2008, 3:31PM
บุคคลทั่วไป
Select Store_No,Total from  (SELECT Sale.Store_No, SUM(Sale.Units_Sold* Item.Unit_Price) as Total from Sale, Item where Sale.Item_No = Item.Item_No group by Sale.Store_No)
where Total  IN (Select Max(Total) from (SELECT Sale.Store_No, SUM(Sale.Units_Sold* Item.Unit_Price) as Total from Sale, Item where Sale.Item_No = Item.Item_No group by Sale.Store_No))
 

  
RSS