SQL ANY and ALL Operators : SQL ANY and ALL Operators are used with a WHERE or HAVING clause. The ANY operator returns true if any of
Read moreAuthor: selva
SQL SELECT INTO Statement
SQL SELECT INTO Statement : SQL SELECT INTO statement copies data from one table into a new table. SELECT INTO Syntax Copy all columns into
Read moreSQL INSERT INTO SELECT Statement
SQL INSERT INTO SELECT Statement : SQL INSERT INTO SELECT Statement copies data from one table and inserts it into another table. INSERT INTO SELECT requires that
Read moreSQL NULL Functions
SQL NULL Functions : SQL NULL Functions are SQL IFNULL(), ISNULL(), COALESCE(), and NVL() Functions Look at the following “Products” table: P_Id ProductName UnitPrice UnitsInStock UnitsOnOrder 1
Read moreSQL Comments
SQL Comments : SQL Comments are used to explain sections of SQL statements, or to prevent execution of SQL statements. Note: The examples in this chapter will
Read moreSQL CREATE DATABASE Statement
SQL CREATE DATABASE Statement : SQL CREATE DATABASE statement is used to create a new SQL database. Syntax CREATE DATABASE databasename; CREATE DATABASE Example The following SQL
Read moreSQL DROP DATABASE Statement
SQL DROP DATABASE Statement : SQL DROP DATABASE Statement is used to drop an existing SQL database. Syntax DROP DATABASE databasename; Note: Be careful before dropping a database.
Read moreSQL CREATE TABLE Statement
SQL CREATE TABLE Statement : SQL CREATE TABLE Statement is used to create a new table in a database. Syntax CREATE TABLE table_name ( column1 datatype,
Read moreSQL DROP TABLE Statement
SQL DROP TABLE Statement : SQL DROP TABLE Statement is used to drop an existing table in a database. (To delete an existing table in a database).
Read moreSQL ALTER TABLE Statement
SQL ALTER TABLE Statement : SQL ALTER TABLE Statement is used to add, delete, or modify columns in an existing table. The ALTER TABLE statement is
Read more