Hi, does anybody know how to express a relational algebra without using aggregate function for this kind of question:

find the most expensive CD in the CD entity

CD(CdNum, Title, price, year)

thanks in advance!

Is this some sort of test question?

select CDMain.*
from CD CDMain
left outer join CD CDSub on CDMain.price < CDSub.price
where CDSub.CdNum is null

blindman