title: SQL automatically filtering results
body: <p>This is the query I'm trying to execute</p>
  <pre><code>select top(50)
  plr_fullnm as Player,
  concat('[b]',runs,'[/b]') as Runs,
  balls as Balls,
  frs as Frs,
  sxs as Sxs,
  round(sr,2) as StrikeRt,
  team as Team,
  opnt as Opposition,
  ground as Ground,
  concat ('Match # ',mat_no) as Scoreboard
  from InningWiseBatRecords
  order by runs desc, sr asc
  </code></pre>
  <p>These are top 4 rows from resulted data</p>
  <pre><code>Player          Runs        Balls   Frs Sxs StrikeRt    Team        Opposition  Ground      Scoreboard
  Shai Hope       [b]98[/b]   137     10  0   71.53       WEST INDIES INDIA       Banglore    Match # 16
  Kieron Pollard  [b]97[/b]   85      9   1   114.12      WEST INDIES PAKISTAN    Jamaica     Match # 14
  Rohit Sharma    [b]97[/b]   83      9   3   116.87      INDIA       PAKISTAN    Mumbai      Match # 19
  Virat Kohli     [b]95[/b]   68      12  4   139.71      INDIA       PAKISTAN    Mumbai      Match # 19
  </code></pre>
  <p>But basically there are 7 more entries where runs is greater than 100, but I don't know somehow those rows keep getting discarded.</p>
  <p>Wait it got solved by when I altered last statement from code to this</p>
  <pre><code>order by InningWiseBatRecords.runs desc, InningWiseBatRecords.sr asc
  </code></pre>
  <p>Why not calling the column name by its table name should have caused the problem though?</p>