Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to write SQL query ??

Bayanna KurubaDec 26 2017 — edited Dec 26 2017

Hi All,

I have query related to SQL query?, like below i have data in DB table. In DB Table contains only two fields like below,

Year       Value

====      =====

2016      256.55 

2020     3156.57

2021    5475.35       

2022    651456.65

i want to display above data like below,

2016      2020       2021        2022 

====      ====      ====         ===

256.55  3156.57   5475.35   651456.65

I am newbie to DB , Please help me to write SQL Query .

Thanks in Advance.

Regards,

Bayanna K.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 23 2018
Added on Dec 26 2017
#general-database-discussions
3 comments
182 views