I want to get an alert email when this solution is edited

×Welcome aboard! We are happy you are here and wish you good net-raft!



Together We Can Simplify The World

the current number of solutions:  2157
.htaccess (1x)    AJAX (13x)    ANGULARJS (133x)    ASP (1x)    ASP.NET (4x)    BACKBONE.JS (47x)    BOOTSTRAP (12x)    C# (199x)    COFFEESCRIPT (28x)    CSS (71x)    HTML (47x)    JADE (32x)    JAVA (51x)    JAVASCRIPT (419x)    JQUERY (357x)    JQUERY MOBILE (5x)    JSON (5x)    LARAVEL (19x)    MYSQL (9x)    NODE.JS (115x)    ORACLE SQL (19x)    PERL (1x)    PHP (266x)    PYTHON (9x)    REACT (60x)    RUBY (23x)    RUBY ON RAILS (1x)    SHELL (1x)    SQL (87x)    SQL SERVER (3x)    TYPESCRIPT (47x)    VB.NET (26x)    W3.CSS (6x)    W3.JS (40x)    
join us

click to create your account

The most viewed SQL solutions by country
Solution Country
convert string to date sqlCinque Terre
How to get the last 10 records using mysql ?Cinque Terre

The most helpful SQL solutions
Likes Solution Technology
25 convert string to date sqlSQL
19 How to get the last record from table using sql ?SQL
17 rows to columns sqlSQL
14 How to convert the values to lowercase using sql ?SQL
11 How to get the last 10 records using mysql ?SQL
Check out all of SQL ...

rows to columns sql

(sql rows columns )

- SQL

 viewed 43

Comment:
SQL

MY_TEST_TABLE:

NAME MONTH INV
name1 201609 30
name2 201610 50
name3 201611 60

------------------------------------------------------------------

select * from MY_TEST_TABLE
pivot (
max(INV)
for MONTH in ( '201609' "201609",
'201610' "201610",
'201611' "201611"
)
)
order by NAME


    

   
created: 13 days ago

The power of the user (%)

35%

Do you know a little more effective code ? Feel free to optimize ...


haven't you found what you're looking for ?
Write us your question ...
Login is not needed.