Rohith

Creator of whiletrue.live.

@rohithreddykota

Operators in SQL

The SQL reserved words and characters are called operators, which are used with a WHERE clause in a SQL query. In SQL, an operator can either be a unary or binary operator. The unary operator uses only one operand for performing the unary operation, whereas the binary operator uses two operands for performing the binary operation.

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

sql rdbms operators

Spark Session

Spark Session is the entry point for spark applications to create RDD, DataFrame, and Dataset.

Posted August 22, 2022 by Rohith ‐ 8 min read

apache spark bigdata distributed-system spark-session

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