/[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.2 by apollock, Mon Aug 9 12:40:39 2004 UTC revision 1.3 by apollock, Tue Aug 10 01:28:52 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    TTITLE "COMP2400: Assignment 1: Question 2"
8    
9  COLUMN PersonID FORMAT A10 HEADING 'PersonID'  COLUMN PersonID FORMAT A10 HEADING 'PersonID'
10    
11  SELECT PersonId  SELECT PersonId
12  FROM Person  FROM Person
13  WHERE Firstname like '&1%' AND Surname = '&2';  WHERE Firstname like '&1%' AND Surname = '&2';
14    
15    EXIT

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

  ViewVC Help
Powered by ViewVC 1.1.22