What would you do if you were asked to identify top-ten products based on their prices? In SQL Server, using a TOP clause with a
Category: Oracle SQL*Plus
Aggregate Functions in Analytic Context
The functions SUM, AVG, COUNT, MIN, and MAX are well-known aggregate functions that we use every day. They are to compute/summarize the multiple rows by
Computing Running & Cumulative Average
This article helps you understand how to calculate the running average and cumulative average on a given data set. As discussed earlier, windowing functions
Oracle Analytical Functions
The below is the compiled list of analytical & advanced functions in Oracle SQL*Plus. Some of them are widely used ones which we will be
Concatenate rows (group concatenation) in MySQL, Hive, SQL Server and Oracle
The CONCAT() function joins the input strings or different column values and returns as a single string. However, if we need to concatenate rows of
DISTINCT vs APPROXIMATE DISTINCT
As all (or most) of us know, SELECT DISTINCT eliminates duplicate records from the results and returns only unique values. But it’s very expensive in
Big Data & SQL 