first function RRS feed

  • Question

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


  • Hi,

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



    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