Re: Please help with SQL

In view of the obvious nature of this thread I'll state what I hope doesn't need to be stated.

Dear Students,

I teach Oracle at the University of Washington. I encourage my students to use these usenet groups as something to monitor and learn from. But if I ever caught one of them posting questions from a mid-term or final here ... well you know what I'm thinking.

Do you think either (A) that your teacher is too stupid to look here, or (B) that you are learning anything if we do your homework for you?

If either of the above ... please reconsider your chosen educational goals. You will fail miserably in a career as an Oracle developer or DBA and quite frankly we don't want you as a co-worker making messes that we have to clean up.

Daniel Morgan

Jim Kennedy wrote:

> Its probably just coincidence. :-)
> Jim
> "Alan" <alanshein_at_erols.com> wrote in message
> news:a77ljb$h7hn7$1_at_ID-114862.news.dfncis.de...
> >
> > Two different people posted the EXACT same question, with a slight
> variation
> > in the "could you tell me how..." part of the question. The SQL problem
> was
> > exactly the same, character for character.
> >
> > "Jeff Kish" <jeff.kish_at_ait-mmii.com> wrote in message
> > news:20je9u89dm9o29rvbvp6q158in8b26he5g_at_4ax.com...
> > > Maybe they just need a hint. If I knew the answer, I would give them a
> > > hint on how to proceed or on how to think the problem through.
> > >
> > > Jeff
> > >
> > > On Mon, 18 Mar 2002 15:30:28 -0500, "Alan" <alanshein_at_erols.com>
> > > wrote:
> > >
> > > >You're nicer than I am. Whenever I'm unsure as to whether a particular
> > > >posting is a homework assignment, I look at the emaill address of the
> > > >poster. Students trying to hide their identities tend to use hotmail or
> > > >yahoo instead of their school email addresses. "Real" questioners
> usually
> > > >work for a company and have company email addresses, or at least a
> > fee-based
> > > >ISP. This was the first time I've seen a duplicate cut-and-paste
> directly
> > > >from the assignment. The epitome of laziness - they didn't even bother
> to
> > > >reword it. Sheesh.
> > > >
> > > >
> > > >"damorgan" <damorgan_at_exesolutions.com> wrote in message
> > > >news:3C96417C.E1E53A94_at_exesolutions.com...
> > > >> Not really. But I'm trying to be kinder and gentler.
> > > >>
> > > >> I think the answer obvious too. And that is why I didn't provide an
> > > >answer.
> > > >>
> > > >> Daniel Morgan
> > > >>
> > > >>
> > > >>
> > > >> Alan wrote:
> > > >>
> > > >> > You have to ask?
> > > >> >
> > > >> > "damorgan" <damorgan_at_exesolutions.com> wrote in message
> > > >> > news:3C960E11.A2E71817_at_exesolutions.com...
> > > >> > > Is this a class project?
> > > >> > >
> > > >> > > Daniel Morgan
> > > >> > >
> > > >> > >
> > > >> > >
> > > >> > > Yuri Rshtuniq wrote:
> > > >> > >
> > > >> > > > Hi !
> > > >> > > >
> > > >> > > > I have a table of employees and their hiredates
> > > >> > > >
> > > >> > > > EMP HIREDATE
> > > >> > > > ------ ------------
> > > >> > > > AAA 10-AUG-82
> > > >> > > > BBB 12-OCT-82
> > > >> > > > CCC 20-JUN-89
> > > >> > > > DDD 12-OCT-82
> > > >> > > > EEE 20-JUN-89
> > > >> > > > FFF 12-OCT-82
> > > >> > > > GGG 10-AUG-82
> > > >> > > > HHH 13-APR-95
> > > >> > > >
> > > >> > > > I want to group employees with the same hiredates and ignore
> > others.
> > > >> > Each
> > > >> > > > "group" hiredate will become the column title:
> > > >> > > >
> > > >> > > > 10-AUG-82 12-OCT-82 20-JUN-89
> > > >> > > > ------------- ------------- ------------
> > > >> > > > AAA BBB CCC
> > > >> > > > GGG DDD EEE
> > > >> > > > FFF
> > > >> > > >
> > > >> > > > Thanks in advance...
> > > >> > >
> > > >>
> > > >
> > >
> >
> >
Received on Wed Mar 20 2002 - 10:02:09 CST