Introduction to For Loop in C
A loop is one of the most fundamental logical structures in computer programming. Defining loops in code allows computers to repeat specific tasks. Defining the loop in a computer program...
Category: Data Science
How to CREATE TABLE in SQL
by Vikram Singh
LAST UPDATED: July 26, 2022, 9:10 IST
When you are working with the large dataset sometime you want to segregate some data and inspect them separately or sometimes you don't have any table or dataset in that...
How to use UNION in SQL
by Vikram Singh
LAST UPDATED: July 26, 2022, 9:06 IST
UNION in SQL is similar to the union of two sets in mathematics that is equal to the set of element that are present in both the set. Similarly UNION...
Introduction to Quicksort Algorithm
LAST UPDATED: July 24, 2022, 15:14 IST
Sorting is organizing the data in a systematic manner, in data structures we have various kinds of sorting algorithms. Quick sort is one of the widely implemented, quick, and efficient...
How to use ORDER BY Clause in SQL
by Vikram Singh
LAST UPDATED: July 22, 2022, 9:55 IST
Sorting the result after extracting the data from the dataset is one of the most basic thing we do to get the pattern or highest/lowest values in a particular field...
SQL query to find second highest salary
by Raju Kumar
LAST UPDATED: July 21, 2022, 10:35 IST
In this article, we will look up a frequently asked SQL interview question. So the problem statement is that given a table of employees with their names and salary.
Logical Operators in SQL
by Vikram Singh
LAST UPDATED: July 22, 2022, 9:51 IST
While working with a large dataset you have to perform a different kind of operation to extract or manipulate the the data from the dataset. To perform these operation we...
SQL Operator: Comparison and Arithmetic
by Vikram Singh
LAST UPDATED: July 31, 2022, 9:13 IST
While working with a large dataset you have to perform a different kind of operation to extract or manipulate the the data from the dataset. To perform these operation we...
How to use WHERE clause in SQL
by Vikram Singh
LAST UPDATED: July 19, 2022, 16:17 IST
SQL WHERE clause is an optional clause to be used with SELECT statement. It is used to filter out the specified record from the dataset/table. So in this article we...
How to use LIMIT clause in SQL
by Vikram Singh
LAST UPDATED: July 19, 2022, 16:17 IST
In this article, we will discuss how to use SQL LIMITs and OFFSET through various examples with WHERE and ORDER BY clauses.