title: skip last record in sql server table
body: <p>i have 37 rows in a table how can i show 36 rows </p>
  
  <pre><code>SELECT c.CommonContentId      
        ,c.Content_Code      
        ,c.Content_Name      
        ,c.Seo_Name      
        ,c.[Description]      
        ,c.Link     
        ,c.Page_Path      
        ,c.ContentType_Code      
        ,c.Creation_Date      
        ,c.Is_Active      
        ,c.Last_Update_Date      
        ,c.Category_Code      
        ,c.Category_Code_Style  
        ,c.Content_Script      
        ,c.Content_Website      
        ,c.Logo_Path      
        ,c.Case_Study      
        ,c.SortOrder      
        ,c.Tags      
        ,c.Vl_Page_Image_Url 
        ,c.Is_Show_Vl_Pages,    
        ,ct.ContentType_Name    
        ,cat.Category_Name    
        ,cat1.Category_Name as Category_Name_Style
        ,ROW_NUMBER() over (ORDER BY c.ContentType_Code ASC, c.Content_Code DESC) as Record_No
        ,CASE WHEN ROW_NUMBER() over (ORDER BY c.ContentType_Code ASC, c.Content_Code DESC) % 3 = 0 
               THEN '' ELSE '' END as Class       
        ,c.SortOrder      
        , Case WHEN len(logo_path) &gt; 1 
                 then 'imagePadded' 
              else '' end as Tetimonial_Image_Css
        ,Case when c.Link like '%vidyard%' 
                then 'http://play.vidyard.com/'+c.Page_Path+'' 
             else 'http://vimeo.com/'+c.Page_Path+'' end   as videolinks  
  
  FROM Content c     
  INNER JOIN  ContentType ct    ON c.ContentType_Code = ct.ContentType_Code       
  LEFT OUTER JOIN Category cat  ON c.Category_Code = cat.Category_Code       
  LEFT OUTER JOIN Category cat1 ON c.Category_Code_Style = cat1.Category_Code    
  WHERE c.Is_Active = 1
  </code></pre>