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

Diff of /uni/COMP2400/q3.sql

Parent Directory Parent Directory | Revision Log Revision Log | View Patch Patch

revision 1.3 by apollock, Tue Aug 10 01:28:52 2004 UTC revision 1.4 by apollock, Tue Aug 10 11:50:42 2004 UTC
# Line 11  TTITLE "COMP2400: Assignment 1: Question Line 11  TTITLE "COMP2400: Assignment 1: Question
11  COLUMN Name HEADING 'Name'  COLUMN Name HEADING 'Name'
12  COLUMN Birthdate HEADING 'Birthdate'  COLUMN Birthdate HEADING 'Birthdate'
13    
14  SELECT Firstname || ' ' || Surname AS Name, Birthdate  SELECT INITCAP(Firstname || ' ' || Surname) AS Name, Birthdate
15  FROM Person  FROM Person
16  WHERE PersonId NOT IN (SELECT PersonId  WHERE PersonId NOT IN (SELECT PersonId
17                          FROM Parents);                          FROM Parents);

Legend:
Removed from v.1.3  
changed lines
  Added in v.1.4

  ViewVC Help
Powered by ViewVC 1.1.22