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

Diff of /uni/COMP2400/q2.sql

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

revision 1.1 by apollock, Sat Aug 7 11:07:01 2004 UTC revision 1.2 by apollock, Mon Aug 9 12:40:39 2004 UTC
# Line 4  Line 4 
4  -- work. It has not been produced, in whole or in part, by another person.  -- work. It has not been produced, in whole or in part, by another person.
5  -- (signed) Andrew Pollock 4137129  -- (signed) Andrew Pollock 4137129
6    
7    COLUMN PersonID FORMAT A10 HEADING 'PersonID'
8    
9  SELECT PersonId  SELECT PersonId
10  FROM Person  FROM Person
11  WHERE Firstname like '&1%' AND Surname = '&1';  WHERE Firstname like '&1%' AND Surname = '&2';

Legend:
Removed from v.1.1  
changed lines
  Added in v.1.2

  ViewVC Help
Powered by ViewVC 1.1.22