Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    aggregate function in relational algebra

    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!

  2. #2
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •