SQL
How to PROPERLY add comments in SQL [Multiple Ways]
We will cover different practical examples to explain how to add SQL comments for Single line comments, Multi-line comments, Inline comments
SQL OUTER JOIN Explained [Practical examples]
SQL OUTER JOIN is used to preserve all of the records that have values in either the left or right table, In the SQL OUTER JOIN all the content of both tables …
SQL INSERT INTO SELECT with Practical Examples
This article of SQL INSERT INTO SELECT, the article begins with the overview of SQL INSERT INTO SELECT with syntax, use of each syntax argument and clause, the …
Delete table in SQL / DROP TABLE in SQL [Practical Examples]
In this article of delete table in SQL, we have covered the delete table command DROP TABLE used to delete a table in SQL with syntax and explanation of each …
How to alter table and add column SQL [Practical Examples]
In SQL, to add column(s) to the existing table SQL ALTER TABLE ADD statement is used, there is no statement like SQL ADD COLUMN to add the column or to modify …