Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: Need SQL Experts Help : Create View !!!!!!!!

Re: Need SQL Experts Help : Create View !!!!!!!!

From: Pete Etten <ettenp_at_reston.btna.com>
Date: 1998/03/17
Message-ID: <6emkjj$2mf$1@news1-alterdial.uu.net>#1/1

select a.course_no, count(distinct b.student_no),count(distinct b.faculty),count(distinct b.major)
from
grade a,
student b
where a.student_no = b.student_no(+)
group by a.course_no
/ Received on Tue Mar 17 1998 - 00:00:00 CST

This message: [ Message body ]
Next message: Steve Dassin: "Re: Need SQL Experts Help : Create View !!!!!!!!"
Previous message: Eric , Chow Hoi Ka: "Need SQL Experts Help : Create View !!!!!!!!"
In reply to: Eric , Chow Hoi Ka: "Need SQL Experts Help : Create View !!!!!!!!"
Next in thread: Steve Dassin: "Re: Need SQL Experts Help : Create View !!!!!!!!"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US