0 votes 0 votes Databases sql databases + – worst_engineer asked Jan 7, 2016 worst_engineer 531 views answer comment Share Follow See all 5 Comments See all 5 5 Comments reply Show 2 previous comments Tendua commented Jan 8, 2016 reply Follow Share sir how alising is done here and can u plz explain the first query if u have time. 0 votes 0 votes Arjun commented Jan 8, 2016 reply Follow Share temp is a new table being formed which has a part and its maxcost and we take a equijoin of it with catalog on pid and cost=maxcost. 0 votes 0 votes Aboveallplayer commented Aug 12, 2016 reply Follow Share yes you can also write Max(cost) AS mcost ... now you can also remove AS ,... Query will work zFine 0 votes 0 votes Please log in or register to add a comment.