MySQL :: Re: In Mysql, How can I get the result which like grouping

Contact MySQL |
Login | Register

The world's most popular open source database

Documentation Downloads MySQL.com

Developer Zone

Section Menu:

New Topic

Re: In Mysql, How can I get the result which like grouping_id() in oracle

Posted by: Peter Brawley
Date: April 01, 2016 10:41AM

MySQL does not have Grouping_Id().

What use is conv() in conv(CONCAT(ISNULL(year)), 2, 10)? IsNull(...) returns 0 or 1, base is irrelevant.

But Group By IsNull(year) groups just by 0 and 1---is that really what you want!?

Navigate: Previous Message• Next Message

Options: Reply• Quote

Subject

Written By

Posted

In Mysql, How can I get the result which like grouping_id() in oracle

ZhanMeng Lv

April 01, 2016 01:33AM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

Peter Brawley

April 01, 2016 10:41AM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

ZhanMeng Lv

April 04, 2016 07:01PM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

Peter Brawley

April 04, 2016 07:57PM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

ZhanMeng Lv

April 04, 2016 08:48PM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

Peter Brawley

April 05, 2016 09:48PM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

ZhanMeng Lv

April 05, 2016 11:07PM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

Peter Brawley

April 07, 2016 10:07AM

Re: In Mysql, How can I get the result which like grouping_id() in oracle

ZhanMeng Lv

April 08, 2016 12:04AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.