Re: SQL PLUS SELECT STATEMENT - HELP ME ASAP!!!
Date: 1995/10/04
Message-ID: <44v0j9$iau_at_madison.tdsnet.com>#1/1
kconboy_at_boeing.hq.nasa.gov wrote:
>
>
> I have two tables:
> Student - St_no, St_fname, St_mname, St_lname
> Enroll - St_no, course
>
> I am trying to create the following listing:
>
> St_no, St_fname, St_mname, St_lname, load_this_semester (count of >enrollment records for each student).
>
> In Foxpro my select statement is:
>
> SELECT Student.St_no, Student.st_fname, Student.st_mname, Student.st_lname,
> COUNT(Enroll.St_no)
> FROM Student, Enroll
> WHERE Enroll.St_no = Student.St-no
> GROUP BY Student.St_no;
>
>
>Please help. This is due next Wednesday, and I can't find an Oracle book or user >anywhere here, only Sybase.
>
>THX.
>
>Kelly Ann Conboy
Use GROUP BY Student.St_no, Student.st_fname, Student.st_mname, Student.st_lname
-- Mike Morgan Technology Integration Services - Unix DBA email: mike.morgan_at_teldta.com TDS Computing Services 301 S. Westfield Road Madison, WI 53705 USA (608)845-4661 "Murphy's Law of computing: Anything that can go wrSegmentation fault(coredump)" *******************************************************Received on Wed Oct 04 1995 - 00:00:00 CET