title: In SQL, How to display a student who is taking more than one subjects?
body: <p>For example - Table name = TABLE</p>
  
  <pre><code>StudentID | SubCode | SubName
  -----------------------------
      1          M1       Math
      1          S1       Science
      1          E1       English
      2          H1       History
      3          G2       Geography
      4          M1       Math    
  </code></pre>
  
  <p>Can we display the answer like this ?</p>
  
  <pre><code>studentid | SubCode | SubName
  ---------------------------------
      1          M1       Math
      1          S1       Science
      1          E1       English
  </code></pre>