Skip to content
rumahmailoa.com

rumahmailoa.com

Books, programming, music, movie, travelling, what else?

  • Home
  • Books
  • Programming
  • Music
  • Movies
  • Travels

Month: May 2019

Posted on May 16, 2019April 19, 2021

Give me even-numbered rows, please!

Here:
SELECT *
FROM (SELECT ROW_NUMBER() OVER(ORDER BY <column_name>) AS ROW_ID, *
FROM <table_name>) AS MyTable WHERE ROW_ID%2=0

What are you looking for?

Twitter

Tweets by @YonathanMailoa

Categories

  • Books (4)
  • Foods (5)
  • Indonesia (2)
  • Miscellaneous (11)
  • Movies (2)
  • Music (3)
  • Quotes (14)
  • Status (1)
  • Technology (16)
    • Computer (8)
    • Gadget (4)
    • Programming (5)
  • Travels (4)
  • Word of the Day (5)

Current Moon Phase


First Quarter Moon
First Quarter Moon

The moon is currently in Cancer
The moon is 7 days old
Joe's

Archives

  • April 2021 (1)
  • May 2020 (1)
  • June 2019 (2)
  • May 2019 (1)
  • December 2017 (4)
  • November 2017 (2)
  • September 2017 (3)
  • October 2015 (1)
  • September 2015 (1)
  • August 2015 (1)
  • February 2014 (3)
  • July 2013 (2)
  • November 2012 (1)
  • August 2012 (3)
  • January 2012 (1)
  • May 2011 (2)
  • April 2011 (5)
  • August 2010 (2)
  • July 2010 (2)
  • May 2010 (1)
  • March 2010 (1)
  • February 2010 (3)
  • December 2009 (1)
  • October 2009 (1)
  • September 2009 (3)
  • August 2009 (6)
  • November 2004 (2)
  • August 2004 (1)
Proudly powered by WordPress