help req in basic t-sql

Below is a table.

 stu_id   meet_doc_id   doc_name   stu_name       dob           value      date
    101        0104          AD          AM      15/06/1950     LMDO     2011-02-15
    101        0105          AD          AM      15/06/1950     CLEAR    2011-02-18
    101        0106          AD          AM      15/06/1950     CLEAR    2011-02-25
    102        0107          AD        开发者_运维问答  AK      12/08/1987     CLEAR    2011-03-28
    102        0108          AD          AK      12/08/1987     LDMO     2011-04-29
    103        0109          PK          LMP     13/07/1970     CLEAR    2011-03-28
    103        0110          PK          LMP     13/07/1970     CLEAR    2011-05-12

What will be the resulting query if I expect to see a result set of

  stu_id    meet_doc_id   doc_name   stu_name      dob          value      date
    101        0104          AD          AM      15/06/1950     LMDO     2011-02-15
    102        0107          AD          AK      12/08/1987     CLEAR    2011-03-28
    103        0110          PK          LMP     13/07/1970     CLEAR    2011-05-12

Your table looks extremely un-normalised with lots of repeating groups but I think you need

;WITH CTE
     AS (SELECT stu_id,
                meet_doc_id,
                doc_name,
                stu_name,
                dob,
                value,
                date,
                ROW_NUMBER () OVER (PARTITION BY stu_id ORDER BY meet_doc_id) AS
                RN
         FROM   YourTable)
select stu_id,
       meet_doc_id,
       doc_name,
       stu_name,
       dob,
       value,
       date
FROM   CTE
WHERE  RN = 1