Group rows by overlapping ranges

I have a dataframe, where the left column is the left – most location of an object, and the right column is the right most location. 128 more words


Using the CUBE clause in Transact SQL

In the previous blog on this site


we used the example shown below to demonstrate the use of  the GROUPING SETS clause in Transact SQL. 950 more words

SQL Server

Group by Grouping Sets

Many SQL Server database developers are familiar with the GROUP BY clause. However T-SQL also supports the GROUPING SETS clause that allows multiple grouping sets to be returned by one query. 608 more words

SQL Server

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="name">Project Milestone Invoicing</field>






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




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