Tag: SELECT

How do you return the a hundred rows starting from 15th?

SELECT column_name FROM table_name LIMIT 15, 100.
The first number in LIMIT is the offset, the second is the number.

What is DDL, DML and DCL ?

SQL commands can be divided into three subgroups.

Data Definition Language (DDL) deals with database schema and descriptions of how the data should reside in the database, therefore language statements like CREATE TABLE or ALTER TABLE belong to DDL.

Data Manipulation Language (DML) deals with data manipulation, and therefore includes most common SQL statements such SELECT, INSERT, etc.

Data Control Language (DCL) includes commands such as GRANT, and mostly concerns with rights, permissions and other controls of the database system.