All students listed in the Students Database

Connected to database:

Prepared SQL statement:
SELECT * FROM student ORDER BY id;
Executed the SQL statement.
Number of rows returned: 7

Student No. Surname First Name Email Course Date Enrolled Fees Paid
  123456   Retallick   Brian   b.bwretallickk@latrobe.edu.au   Computing   24/02/2007   0.00
  123458   Hewitt   Lleyton   lhewitt@students.latrobe.edu.au   Business/Computing   24/02/2005   800.00
  123460   Federer   Roger   rogerf@tennis.ch   Business   20/07/2005   900.00
  123465   Nadal   Rafael   rafael@rafaelnadal.com   Business   20/07/2005   900.00
  987654   Molik   Alicia   alicia@smallpond.com   Business/Computing   24/04/2007   200.00
  987655   Hingis   Martina   martina@ironbark.geneve.ch   Computing   07/07/2006   350.00
  987660   Hewitt   Jaslyn   jhewitt@students.latrobe.edu.au   Computing   24/02/2006   350.00

Return to Table of Contents

Written by: Darren Waters & Anthony Robinson in 1999 for the Major Project subject.
Maintained by: Brian Retallick
Last Update: 25th February 2003