Hi,

can one tell me how would we write down relational calculus query for
one in which we have group by and having clauses ?

Regards,

Miten.
miten.mehta (AT) morganstanley (DOT) com
imiten (AT) yahoo (DOT) com

On Mar 10, 6:05*am, miten.me... (AT) morganstanley (DOT) com wrote:
I, for one, do not understand your question. Please rephrase.


David Fitzjarrell

miten.mehta (AT) morganstanley (DOT) com wrote:

Oracle version in the format of Maj.Min.V.Patchset?
what have you tried? table defs? sample data? sample query? did it work?
errors? get a book - if morgan stanley is your employer, no wonder we
are in such serious financial trouble - we have ignorant people asking
these sorts of questions. The good news is that ignorance can be cured
with a lot of hard work and willingness to learn. Install OracleXE on a
PC or Linux box (same thing ) and start testing and reading and more
testing and reading. BTW - Google can be your friend too...

http://lmgtfy.com/?q=oracle+group+by+having+clause

(For those of you who have not tried lmgtfy I think it is hilarious!!)

On 11 Mar, 01:11, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:
lmgtfy.com? Brilliant

Cheers,

-g

ddf (oratune (AT) msn (DOT) com) wrote:
: On Mar 10, 6:05=A0am, miten.me... (AT) morganstanley (DOT) com wrote:
: > Hi,
: >
: > can one tell me how would we write down relational calculus query for
: > one in which we have group by and having clauses ?
: >
: > Regards,
: >
: > Miten.
: > miten.me... (AT) morganstanley (DOT) com
: > imi... (AT) yahoo (DOT) com

: I, for one, do not understand your question. Please rephrase.


Perhaps he means the logic predicate type notation, an example expression
stolen from Wikipedia...

{ t : {name} | . s : {name, wage}
( Employee(s) . s.wage = 50.000 . t.name = s.name )
}


There are various such "mathematical/logical" ways of writing set
expressions that correspond to what a relational database does.

I would guess he wants to figure out how to write group by or having using
some such notation.

$0.10

On Mar 11, 1:11 am, Michael Austin <maus... (AT) firstdbasource (DOT) com> wrote:



Yep - go to an educational institution and attend classes - or read
a book by "Date".


OS - version and machine? CPU? RAM? Disk config?

ROTFLMAO...



I have a prediction that there'll be a rash of http://lmgtfy.com/
posts
in the near future! Brilliant - and who says geeks have no
sense of humour?


Paul...