codingstatus

This tutorial will learn you SQL INSERT INTO with definition, syntax, query, & example. You will learn to insert data into a table with or without a column name. After reading each point, you will easily execute an insert query to store values in the database. So, read the complete tutorial carefully lest you should … Read more

In this tutorial, the SQL ORDER BY statement is explained with definition, syntax, example, ASC & DESC keyword. Using it, you will learn how to sort multiple column data in ascending or descending order. ORDER BY clause is mainly used with the SELECT statement. If you don’t know about the SELECT statement, Don’t worry, I … Read more

SQL Case Statement -The case statement is the heart of SQL. Because It can control the execution of different sets of statements. It handles the WHEN/THEN statement.  By using it, we can filter & optimize queries through selection rows that satisfied our requirements. We can also use it in an insert, select, update or delete … Read more

In this tutorial, we are going to discuss SQL aggregate functions like COUNT(), SUM(), MAX(), MIN(). AVG() with an example, definition & syntax. you will learn it in some simple steps that are very simple to understand. Aggregate Functions in SQL Aggregate functions calculate the string & numeric values of multiple records of a particular … Read more