Category: DB
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...
DB
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...
DB
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...
DB
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...
DB
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...
DB
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...