|
|
Posted by Steve Kass on 11/15/06 05:11
[responding only to comp.databases.ms-sqlserver, due to newsreader limitations]
Another option, probably more efficient in most cases, is
select * from sometable
where rec_sequence = (
select max(rec_sequence)
from alppremh
where rec_id = 4883493
)
and rec_id = 4883493
Steve Kass
Drew University
http://www.stevekass.com
klabu wrote:
> How to write an equivalent SQL like this (which works on Oracle):
>
> SELECT * FROM sometable
> WHERE rec_id, rec_sequence
> IN (SELECT rec_id, MAX( rec_sequence) FROM alppremh GROUP BY rec_id)
> and rec_id = 4883493
>
>
Navigation:
[Reply to this message]
|