Tags » GROUP BY

Duplicates in two columns in a table

That’s a painting of my cat Thor in the backyard.  Apparently he’s looking at the hose, despite the fact that to his right the yard is full of California Poppies. 151 more words

odoo tree view default group by using filed

<record id="action_project_milestone_invoicing_view" model="ir.actions.act_window">

<fieldname="type">ir.actions.act_window</field>

<fieldname="name">Project Milestone Invoicing</field>

<fieldname="res_model">project.milestone.invoicing</field>

<fieldname="view_mode">tree,form</field>

<fieldname="context">{'group_by':['project']}</field>

<fieldname="view_type">form</field>

<fieldname="help"type="html">

<pclass="oe_view_nocontent_create">Create the first Project with Milestone</p>

</field>

</record>

Odoo

Much Ado About Nothing – NULL Handling

For a better value proposition to the reader, I’ll leapfrog to NULL handling after a small introduction to SQL.

PL/SQL stands for Procedural Language/Structured Query Language. 1,253 more words

Aggregate Func

GROUPING_ID() Explained

The GROUPING_ID() aggregate function in SQL Server returns the integer value of a bit vector whose bits are set (1) when the respective arguments to GROUPING_ID() are not included in the grouping. 640 more words

SQL Prompt: For Your Group By Problems

The Joys of SQL:

Did you know that the SQL language allows you to do amazing analysis of data such as aggregate functions?

SELECT t.session_id,
       t.request_id,
       SUM(t.user_objects_alloc_page_count) AS UserObjectAllocated,
       SUM(t.user_objects_dealloc_page_count) AS UserObjectDeallocated
FROM sys.dm_db_task_space_usage AS t
GROUP BY t.session_id,
         t.request_id;
… 609 more words
Sql-server

NO_DATA_FOUND when using aggregate functions like count, min, max, avg...

A common misconception when writing PL/SQL select …. into … statements is that if it is an aggregation query (a query that is using an aggregation like count, max, min, avg, etc.) then they always return a result – possibly null – so a NO_DATA_FOUND exception will never occur. 639 more words

SQL

T-SQL Grouping Set Showcase

Greetings all,

In the interim, whilst I juggle my time to get more in-depth posts rolled out (like the one surrounding Alexa skills), I back-tracked once again to look at overlooked features from the distant past of SQL 2008. 3,036 more words

Code