Results 1 to 2 of 2

Thread: FIRST

  1. #1
    Join Date
    Dec 1969

    Default FIRST

    In MSAccess I use FIRST to take only the first field with the same contente (ex. SELECT First(code),desc ... FROM ... GROUP BY ... etc); in SQLServer FIRST is not accepted as in access, someone knows a solution or another keyword that works as FIRST but in SQLServer?<BR><BR>thanks<BR>Jacopo

  2. #2
    Join Date
    Dec 1969

    Default RE: FIRST

    I&#039;m pretty sure that you don&#039;t put anything but the field name:<BR><BR>In Access:<BR>SELECT FIRST(Fieldname)<BR><BR>In SQL Server:<BR>SELECT Fieldname<BR><BR>-Doug

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts