Laurel@House

Sunday, 25 October 2015

how to show only even or odd rows in sql server

Odd No:- 
 SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY sal DESC) row_number, sr,sal FROM empsal) a WHERE (row_number%2) = 1

Even No:-
      SELECT * FROM (SELECT ROW_NUMBER () OVER (ORDER BY sal DESC) row_number, sr,sal FROM 
Posted by Rahad Rahman at 03:11
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest

No comments:

Post a Comment

Newer Post Older Post Home
Subscribe to: Post Comments (Atom)

About Me

Rahad Rahman
View my complete profile

Blog Archive

  • ►  2019 (5)
    • ►  September (3)
    • ►  August (1)
    • ►  February (1)
  • ►  2016 (2)
    • ►  May (1)
    • ►  March (1)
  • ▼  2015 (31)
    • ►  December (4)
    • ►  November (3)
    • ▼  October (13)
      • how to show only even or odd rows in sql server
      • TRY...CATCH (Transact-SQL)
      • SQL Server CROSS APPLY and OUTER APPLY
      • SQL - TRUNCATE TABLE Command
      • SQL - Date Functions
      • Triggers -- SQL Server
      • SQL - Indexes
      • SQL - Distinct Keyword
      • SQL - AND and OR Conjunctive Operators
      • SQL - Operators
      • SQL - Data Types
      • Difference Between Primary Key and Unique Key In S...
      • How to Install a Clustered SQL Server 2012
    • ►  September (8)
    • ►  July (3)
Thanks to Laurel@House. Watermark theme. Powered by Blogger.