locked
first function RRS feed

  • Question

  • which is the equivelant sql function for ms access "first" function?
    Monday, September 15, 2008 7:18 AM

Answers

  • Hi,

    Though not exactly the same but in t-sql you have

    TOP

     

    select top 1 column_name from table_name

     

     

    Also don't use the order by if you want exactly same behaviour as in ms access.

     

    Monday, September 15, 2008 7:41 AM