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

Annotation of /uni/COMP2400/q2.sql

Parent Directory Parent Directory | Revision Log Revision Log


Revision 1.4 - (hide annotations)
Tue Aug 10 11:43:50 2004 UTC (18 years, 1 month ago) by apollock
Branch: MAIN
Changes since 1.3: +1 -1 lines
Enhanced

1 apollock 1.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 apollock 1.3 TTITLE "COMP2400: Assignment 1: Question 2"
8    
9 apollock 1.2 COLUMN PersonID FORMAT A10 HEADING 'PersonID'
10    
11 apollock 1.1 SELECT PersonId
12     FROM Person
13 apollock 1.4 WHERE UPPER(Firstname) like UPPER('&1%') AND UPPER(Surname) = UPPER('&2');
14 apollock 1.3
15     EXIT

  ViewVC Help
Powered by ViewVC 1.1.22