title: Select N Row with DB2 in Visual Studio
body: <p>I want to get the first 95 data from DB2 in Visual Studio. I'm using table adapter and I have this query,</p>
  
  <blockquote>
    <p>SELECT        * FROM            ASEINDTA.TRX_BWS WHERE        (DKLDATE
    = '2019-10-31') Fetch First 95 Rows Only</p>
  </blockquote>
  
  <p>or this</p>
  
  <blockquote>
    <p>SELECT        * FROM            ASEINDTA.TRX_BWS WHERE        (DKLDATE
    = '2019-10-31') ORDER BY Col[ 1 ]...Col[ n ]
    Fetch First 95 Rows Only</p>
  </blockquote>
  
  <p>But when I click Query Builder, this error appears.
  <a href="https://i.stack.imgur.com/9Is1L.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/9Is1L.png" alt="image error"></a></p>
  
  <p>But when I tried it in DBVisualizer, it works. How do I get that data? A help would be appreciate. Thanks</p>