Category Archives: SQL

SQL GROUP BY CLAUSE

SQL GROUP BY CLAUSE. GROUP BY Clause - The SQL GROUP BY Clause is used to returns all records togather with specified column and perfom aggregate function on one or more columns.

DELETE Statement in SQL – DML Statements

DELETE Statement in SQL – DML Statements. The DELETE Statement – The DELETE Statement is used to delete the records of an existing table.

UPDATE Statement in SQL – DML Statements

UPDATE Statement in SQL – DML Statements. The UPDATE Statement - The UPDATE Statement is used to modify the records of existing table.

INSERT Statement in SQL – DML Statements

INSERT Statement in SQL – DML Statements. INSERT Statement - The INSERT Statement is used to insert new records in to a table.

SELECT Statement in SQL – DML Statements

SELECT Statement in SQL - DML Statements. SQL SELECT Statement - The SELECT statement is used to select / retrieve data from a table in the database. The SQL SELECT Statement is most commonly used statement.

TRUNCATE TABLE Command in SQL – DDL Statements

TRUNCATE TABLE Command - DDL Statements. The TRUNCATE TABLE command used to delete all the rows/records from entire table.

DROP Command in SQL – DDL Statements

DROP Command - DDL Statements, The DROP command used to remove the database object from DBMS, and delete the table from database.

USE Command in SQL – DDL Statements

USE Command - DDL Statements, The USE command allows you to specify the database you wish to work with within your DBMS.

ALTER Command in SQL – DDL Statements

ALTER Command - DDL Statements, The ALTER command used to modify the structure of table without deleting and recreating. We use ADD and MODIFY with ALTER Command.

CREATE Command in SQL – DDL Statements

CREATE Command - DDL Statements, CREATE Command used to create new database in database management system and create new table in database.

Data Manipulation Language – DML Statement

Data Manipulation Language - DML Statement, Use SELECT Command, INSERT Command, UPDATE Command and DELETE Command.

Data Definition Language – DDL Statement

Data Definition Language - DDL Statement, DDL Commands CREATE, DROP, ALTER, TRUNCATE TABLE, RENAME..