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 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 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.

In this page we are discussing about the usage of subquery to update the values of columns with the UPDATE statement.

In this page we are going to discuss, how an MAX() function in a subquery can be used in an INSERT INTO statement to insert records in a table.