6 Replies Latest reply: Apr 26, 2016 8:48 AM by Sunny Talwar RSS

    Return only 1 record in a table

    Andrew Thomas

      Hi

       

      I have a table that contains employee number and employee name, in some cases the table has 2 records

       

      Eg

       

      Employee no          EmployeeName

      20000005               JOE BLOGS

      20000005                joe blogs

       

      I need to return just 1 record