Post reply

Select w/ Max

  • April 3, 2007 at 12:55 pm

    #698383

    select * from (select top 1 * from AAA where loaded_unloaded ='U' order by scale_dt desc)A

    UNION

    select * from (select top 1 * from AAA where loaded_unloaded ='L' order by scale_dt desc)B

  • April 3, 2007 at 12:58 pm

    #698384

    select * from (select top 1 * from AAA where loaded_unloaded ='U' order by scale_dt desc)A

    UNION

    select * from (select top 1 * from AAA where loaded_unloaded ='L' order by scale_dt desc)B

Viewing 2 posts - 16 through 17 (of 17 total)

You must be logged in to reply to this topic. Login to reply