dbTalk Databases Forums  

finding last date

comp.databases.oracle.server comp.databases.oracle.server


Discuss finding last date in the comp.databases.oracle.server forum.



Reply
 
Thread Tools Display Modes
  #11  
Old   
Robert Hicks
 
Posts: n/a

Default Re: finding last date - 05-23-2007 , 02:12 PM






On May 23, 2:49 pm, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com>
wrote:
Quote:
-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

fitzjarr... (AT) cox (DOT) net wrote:

Such is the price

you pay for not providing accurate details regarding what you are
trying to do.

Homework?

Thanks for the cynicism...but no. It is work work.

Robert



Reply With Quote
  #12  
Old   
valigula
 
Posts: n/a

Default Re: finding last date - 05-23-2007 , 02:23 PM






On 23 mayo, 21:12, Robert Hicks <sigz... (AT) gmail (DOT) com> wrote:
Quote:
On May 23, 2:49 pm, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com
wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

fitzjarr... (AT) cox (DOT) net wrote:

Such is the price

you pay for not providing accurate details regarding what you are
trying to do.

Homework?

Thanks for the cynicism...but no. It is work work.

Robert
Thakns for your help but ..

group by ?? good try already did that!!

Problem is , i need to return 7 others columns from that query
fitering only from the cod that must be unique and the date that can
be different even null. I also did the alias trick but i does not work
either.

thanks Mladen that was where i was stack ...
A.



Reply With Quote
  #13  
Old   
valigula
 
Posts: n/a

Default Re: finding last date - 05-23-2007 , 02:32 PM



On 23 mayo, 21:12, Robert Hicks <sigz... (AT) gmail (DOT) com> wrote:
Quote:
On May 23, 2:49 pm, Frank van Bortel <frank.van.bor... (AT) gmail (DOT) com
wrote:

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

fitzjarr... (AT) cox (DOT) net wrote:

Such is the price

you pay for not providing accurate details regarding what you are
trying to do.

Homework?

Thanks for the cynicism...but no. It is work work.

Robert
Reading this theat i just can apologise.

Thakns for your help but ..

group by ?? good try already did that!!

Problem is , i need to return 7 others columns from that query
filtering only from the cod that must be unique and the date that can
be different even null. I also did the alias trick but i does not work
either.

thanks Mladen i quiet doubt that is basic sql but i am not going to
enter into this, i did search before asking.

A.



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.