Member Avatar for 080346

hello world;
i want to know how i represent or write "IN" in relational algebra;
lets if i have the following query; then how i write in relational algebra

select CourseTitle, Amount
from DegreeCourse, Fee
where DegreeCourse.FeeType = Fee.FeeType and
Amount IN ( select MAX(Amount) from Fee );

  • 2 Contributors
  • 1 Reply
  • 40 Views
  • 4 Days Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Why you need to use IN , as MAX() will return a single record ?

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.