Re: query issue

From: curwen <josephcurwen_at_despammed.com>
Date: 5 Feb 2004 08:21:24 -0800
Message-ID: <cc68edc4.0402050821.4c3bd50e@posting.google.com>

> To add to what Daniel said.. in a blunt way using nice friendly
> letters... empty your cup of preconceptions of what you think a RDBMS
> is and then fill it with some RTFM'ing.

I know you'll probably start to rolling on the floor laughing, but I'm gonna ask anyway:
what the h*** is a rtfm'ing ?

> > I've tried the the following , but doesn't work:
> >
> > select distinct numb,fk1
> > from <table>
>
> It does work - just not the way you think. :-)

hey, what's up ?
I'm writing in a It Professional newsgroup I'm expecting to find people smart enough to understand even if I don't write it down entirely what I was trying to say.. ;)

anyway, to explain myself better, the desidered behaviour is the one that comes out from the following:

select n_id,n_number,fk1 FROM numbers
where n_id in
(select max(n_id) from numbers group by n_number)

I'm just worried about performances:
my question was :'is there any way to avoid nestes queries'?

ps ..and getting the same result, of course

regards
jc Received on Thu Feb 05 2004 - 10:21:24 CST