Back To Basics

Back To Basics

BTB – Aggregation

TweetShareSharePin0 SharesIt is time for aggregating data, using the GROUP BY keyword. Hint: I will be using the emp/dept tables used by Oracle for demo in all demonstrations. I recommend Live SQL for playing, it is a great place to test SQL and learn from others. You can also sign up for a database for free (for a short time) on Oracle’s cloud. I recommend beginning with Live SQL and moving to paid services when you are ready, Hint II: You can run the code […]

Back To Basics

Back to basics

TweetShareSharePin0 SharesLet’s start with baby steps We’re all very excited to read a new blog with a neat trick or a cool and complex feature or even a very useful undocumented function. However that is preaching to the choir. We do that and then we get together and complain that there is no new fresh talent in the database business. Well, it may be a bit hard to get into it if all we do are talking new features and really […]