Rohith

Creator of whiletrue.live.

@rohithreddykota

Aggregate Functions in SQL

Functions in SQL enable we to perform feats such as determining the sum of a column or converting all the characters of a string to uppercase.

Posted September 20, 2022 by Anusha and Rohith ‐ 5 min read

⌖ sql rdbms

Date and Time Functions in SQL

We live in a civilization governed by times and dates, and most major implementations of SQL have functions to cope with these concepts.

Posted September 20, 2022 by Anusha and Rohith ‐ 4 min read

⌖ sql rdbms functions

Arithmetic Functions in SQL

Many of the uses we have for the data we retrieve involve mathematics. Most implementations of SQL provide arithmetic functions similar to the functions covered here.

Posted September 20, 2022 by Anusha and Rohith ‐ 8 min read

⌖ sql rdbms arithmetic-function

Spark Context

SparkContext is the the entry point for spark application prior to spark 2.x. SparkSession was introduced as a common entry point for SparkContext, SQLContext, StreamingContext, HiveContext. SparkContext is still being used even after spark 2.x release.

Posted August 23, 2022 by Rohith ‐ 4 min read

⌖ apache spark bigdata distributed-system

Character Functions in SQL

Many implementations of SQL provide functions to manipulate characters and strings of characters. This section covers the most common character functions.

Posted September 20, 2022 by Anusha and Rohith ‐ 7 min read

⌖ sql rdbms character-function