Member Avatar for kz07
kz07 0 Newbie Poster

how do i translate group by and having into relational algebra?

SELECT employee-name
FROM EMPLOYEE, DEPARTMENT
GROUP BY EMPLOYEE.suburb
HAVING EMPLOYEE.suburb = DEPARTMENT.suburb;

thanks.

Edited by peter_budo because: Keep It Organized - For easy readability, always wrap programming code within posts in [code] (code blocks)
  • 1 Contributor
  • 0 Replies
  • 66 Views
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.