SQL behind Business Intelligence
That title is sounding odd I admit it.
In the french forums développez.net there is a regular mistake that I try to emphasize on each time I read it, it's the use of GROUP BY without any aggregate functions to perform a regular DISTINCT operation.
Here's a very simple example (if you're not working on Oracle just [...]
NoCOUG Challenge
After many months, Iggy Fernandez published his own solution of the first annual NoCOUG SQL Challenge.
His solution was performing fast from the beginning according to the graph he sent to Chen Shapira back in the announcement days :
I never managed
This is the query I sent to the TC team. I published it when I sent it, but they prefer to keep solution secret as long as the closure date isn't in the past, which I can understand.
I had fun using PIVOT and UNPIVOT operators to reduce the query size.
PIVOT / UNPIVOT syntax isn't part [...]
When trying to solve last T-SQL Challenge I did find a query which fits well in both SQL Server and Oracle (with some syntax tweaking) and seems quite effective to me even on a ten millions rows table.
I said I'll try to use the more advanced analytics function of Oracle to solve the problem, and [...]
Beyondrelational published their new TSQL Challenge #9, and as usual Antoine Gémis translated it in french.
They have taken redefined the goal about those challenges which I think is a very nice move.
The goal of TSQL Challenges is to help people enhance their SET based query writing skills.
Most of the times, a SET based query performs [...]