Category: DB

Aggregate Methods, Group By And Having in SQL

This article discusses MySQL aggregate functions, Aggregate Methods In this lesson, we'll demonstrate working with a few of the important aggregate functions. Example Syntax : SELECT...

When to use order by clause in SQL understand in 6 steps

In a previous couple of articles, we have seen how to query data from a table. The retrieved rows aren't printed in any particular...

How to use alterations and alter index in SQL

Alterations In this article we discuss how to modify various database structures once they are created. MySQL allows us to change our minds about the entities...

How to write nested queries in MySQL

This article discusses nested queries that result in a single value. Nested Queries In this article, we'll examine nested queries, a query within another query. With...

What is Primary Key and Indexes?

This article explains the concept of an index and Primary Key and its utility in databases. Every time a query that contains a WHERE clause...

Update and Truncate Data in SQL

This article discusses how to use the Update clause in MySQL. We can use the UPDATE statement to change the value of a column for...

SUBSCRIBE TODAY

What are Triggers?

EXPLAIN plan in SQL

How to use TRUNCATE for MYSQL