Tech
Forums
Jobs
Books
Events
Videos
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
4
Answers
SQL Query Solution
balaji palani
8y
397
1
Reply
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 ║
Post
Reset
Cancel
Answers (
4
)
Next Recommended Forum
Inserting multiple records @ once, trying to group with 1 Id
Generate dynamic colum using sp