Home Forums SQL Server 7,2000 T-SQL T-SQL Equivalent to MS Access'' "First" function RE: T-SQL Equivalent to MS Access'''' "First" function

  • March 28, 2007 at 7:44 am

    #697393

    I found this via a Google search:

    SELECT Column1, column2

    from table1

    where column1 in (SELECT min(column1) from table1 group BY Column1)

     

    It seems to work for my purpose.  Any thoughts.  Thanks.

    Chris