In this page we are going to discuss, how two or more tables can be involved as an alias and join themselves to make a view in CREATE VIEW statement.

In this page, we are discussing the usage of DISTINCT clause and aggregate functions and operators with the select statement, resultant a subquery, which helps to make a VIEW in a CREATE VIEW statement.

In this page we are going to discuss, how two or more query can be placed one into another to make a view using aggregate functions and operators in a CREATE VIEW statement.

In this page we are going to discuss, how rows can be remove from a table by SQL DELETE statement along with the SQL MIN() and COUNT() function.

In this page we are going to discuss, how rows can be remove from a table by SQL DELETE statement along with the SQL MIN() function.

In this page we are going to discuss, how rows can be remove from a table by SQL DELETE statemtnt with the use of IN operator and SUBQUERIES.

In this page we are going to discuss, how table aliases( when two or more tables used in a query then alias make it easy to read and write with a short name comes after the table name in the FROM) can be used with SUBQUERIES (A SELECT statement withi (...)

In this page we are going to discuss, how SUBQUERIES (A SELECT statement within another SELECT statement can be used as a subquery )along with SQL DELETE command can be used to perform a deletion.

In this page we are going to discuss the usage of IN operator and MIN() function along with the UPDATE statement to make changes within the specified columns

In this page we are going to discuss about the usage of IN within a subquery with the UPDATE statement, to update the specified columns.