| I´m feeling stupid but... [message #66054] |
Fri, 26 October 2001 02:10  |
Baratta
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
..can anyone help me?
A friend has mailed me this and I´ve fried my brain with it.
TIMESTP SNAME SVALUE
-------------------- ------ ------------
2001/10.01 00:00:54 HUMED 33,9013937
2001/10.01 00:00:54 HYDR 397,851378
2001/10.01 00:00:33 PTC1 80,3393444 <<
2001/10.01 00:00:54 PTC1 80,3393444
2001/10.01 00:00:33 PTC2 28,5317456 <<
2001/10.01 00:00:54 PTC2 28,6017532
We look for a statement to get this:
2001/10.01 00:00:54 HUMED 33,9013937
2001/10.01 00:00:54 HYDR 397,851378
2001/10.01 00:00:54 PTC1 80,3393444
2001/10.01 00:00:54 PTC2 28,6017532
It means: groups with the same SNAME, we take those with the most recent date.
Without additional columns, neither things like that.
We did it with PL/SQL but it is not interesting.
Thanks,
----------------------------------------------------------------------
|
|
|
|
| Re: I´m feeling stupid but... [message #66056 is a reply to message #66054] |
Fri, 26 October 2001 08:25  |
Oraculo
Messages: 1
Registered: October 2001
|
Junior Member |
|
|
Why do we concern ourselves with programming? I say let this forum be about chicks, drugs, partying, yaeger meister, and guns!!!!!! Here is one to start us off with!
----------------------------------------------------------------------
|
|
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
