/[cvs.andrew.net.au]/uni/COMP2400/q6.sql
ViewVC logotype

Contents of /uni/COMP2400/q6.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.2 - (show annotations)
Tue Aug 10 01:28:52 2004 UTC (18 years, 1 month ago) by apollock
Branch: MAIN
Changes since 1.1: +4 -0 lines
Spruced up

1 -- I have read the ANU Code on "Academic Honesty in Learning and Teaching",
2 -- and I declare that, except where appropriately attributed, the content
3 -- of the file I have submitted for this assignment is entirely my own
4 -- work. It has not been produced, in whole or in part, by another person.
5 -- (signed) Andrew Pollock 4137129
6
7 TTITLE "COMP2400: Assignment 1: Question 6"
8
9 SELECT motherid, fatherid
10 FROM parents
11 GROUP BY motherid, fatherid
12 HAVING COUNT(personid) = (SELECT MAX(COUNT(personid))
13 FROM parents
14 GROUP BY motherid, fatherid);
15
16 EXIT;

  ViewVC Help
Powered by ViewVC 1.1.22