The MIN and MAX functions in SQL Server can be used separately on a column level to find the lowest and maximum value of a
Category: RDBMS
First Value and Last Value Functions in SQL Server
The First_Value function in SQL Server returns the first value in an ordered set of values and the Last_Value function returns the last value in
SQL Server Built-in Functions
In SQL, a built-in function is a programming object that takes zero or more inputs and returns a value. A feature that is built into
SQL-92 and SQL-89 Joins
SQL-92 and SQL-89 joins are supported by most RDBMSs, including Apache Impala. This article will explain how the syntax is written in both ways and
SQL vs NoSQL vs BigData
Some argue that “..relational databases are out of date and do not match current trends..”, while others contend that “..SQL cannot handle big data..” and
EMP and DEPT Datasets for MySQL
In several of the SQL Server and MySQL examples in my blogs, I used Oracle’s “EMP” and “DEPT” datasets. In other RDBMSs, creating such tables
Big Data & SQL 