SQL
-
Software Development
How to remove duplicate rows from a table in SQL
There are a couple of ways to remove duplicate rows from a table in SQL e.g. you can use a…
Read More » -
Software Development
Using Apache Spark SQL to Explore S&P 500, and Oil Stock Prices
This post will use Apache Spark SQL and DataFrames to query, compare and explore S&P 500, Exxon and Anadarko Petroleum…
Read More » -
Software Development
SQL Query on Mixed Schema Data Using Apache Drill
You may have heard this statement before: Apache Drill does schema discovery on-the-fly. What does that mean, and why should…
Read More » -
Software Development
SQL for Application Developers
“SQL? Isn’t that just something my ORM tools use?” Often application developers can and should remain at least one level…
Read More » -
Software Development
Correlated Subqueries are Evil and Slow. Or are They?
A common myth in SQL is the idea that correlated subqueries are evil and slow. For example, this query here:…
Read More » -
Software Development
NetBeans SQL Profiler – Take it for a Spin!
The upcoming release of NetBeans, currently in active development and testing, boasts plenty of new features. A few of them…
Read More » -
Software Development
10 SQL Tricks That You Didn’t Think Were Possible
Listicles like these do work – not only do they attract attention, if the content is also valuable (and in…
Read More » -
Software Development
Time for some Funky SQL: Prefix Sum Calculation
This Stack Overflow question has yet again nerd-sniped me: [finding the] maximum element in the array that would result from…
Read More » -
Software Development
Apache Spark as a Distributed SQL Engine
SQL has been here for awhile and people like it. However, the engines that power SQL have changed with time…
Read More »
