title: how to skip rows in mysql query
body: <p>Here is my sp codes. I want to select next different 6 rows from result of this sp. How can I do that?</p>
  
  <pre><code>SELECT  N.NewsId,
          N.HeadCaption,
          (SELECT Name FROM NewsCategory 
           WHERE NewsCategoryId = N.HeadLineCategoryId) Category,
          N.PicUrl,
          N.Creation,
          SUBSTRING((fnStripTags(N.Description)),1,75) AS ShortDescription
  FROM    News N
  INNER JOIN
          (SELECT  HeadlineCategoryID, MAX(NewsID) max_id
           FROM    News           
           GROUP   BY HeadlineCategoryID) N_ 
     ON N.HeadlineCategoryID = N_.HeadlineCategoryID AND
        N.NewsID = N_.max_id
  ORDER BY N.ViewIndex DESC  
  LIMIT 6;  
  </code></pre>