Balaji Palani

Balaji Palani

  • NA
  • 364
  • 63.6k

SQL Query Solution

May 14 2016 12:04 AM
I have one table with rows(1 to 5) and need a output like below
Table:
║no ║Years ║
╠══╬════║
║ 1  ║ 2001 ║
║ 2  ║ 2002 ║
║ 3  ║ 2003 ║
║ 4  ║ 2004 ║
Output :
║no ║Years║
╠══╬════
║ 1  ║ 2001 ║
║ 2  ║ 2002 ║
║ 3  ║ 2003 ║
║ 4  ║ 2004 ║
║ 4  ║ 2004 ║
║ 3  ║ 2003 ║
║ 2  ║ 2002 ║
║ 1  ║ 2001 ║
 

Answers (4)