Re: Crack this SQL Query

From: Johnnie Leung <jsleung_at_telecom-digest.zzn.com>
Date: Mon, 11 Oct 1999 01:37:41 -0700
Message-ID: <QmhM3.4379$T77.258406@news.uswest.net>

VSNL News <abcd_at_efgh.ijk> wrote in message news:7tt6jp$o6n$1_at_news.vsnl.net.in...

Posting anonymously...

> hii there. i have a very unique SQL query, which i have been posting to
many
> oracle pros. but i can't seem to get the right answer. so if anyone can
> crack this, i'll be very grateful.

Whoa, and they are 'pros'?

> the query goes like this .... GIVE THE SELECT STATEMENT TO LIST THE
EMPLOYEE
> NAMES AND THEIR CUMULATIVE SALARIES, DEPARTMENT WISE. you have to use the
> EMP table which comes along with the demo database.

Ahem... this is even worded like a homework assignment problem.

Hint: use the 'sysdate' function in your select to get the cumulative salary.

JL Received on Mon Oct 11 1999 - 03:37:41 CDT