SQL | The BETWEEN Operator
BETWEEN Operator Example The “Persons” table: Now we want to select the persons with a last name alphabetically between “Hansen”…
Tag: Advanced SQL tutorial
SQL | The IN Operator
The IN operator allows you to specify multiple values in a WHERE clause. SQL IN Syntax: IN Operator Example The…
SQL | The LIKE Operator
SELECT column_name(s) FROM table_name WHERE column_name LIKE pattern LIKE Operator Example The “Persons” table: Now we want to select the…
SQL ADVANCE | The TOP Clause
SELECT TOP number|percent column_name(s) FROM table_name SQL SELECT TOP Equivalent in MySQL and Oracle: MySQL Syntax: SELECT column_name(s) FROM table_name…
SQL | The DELETE Statement
DELETE FROM table_name WHERE some_column=some_value Note: Notice the WHERE clause in the DELETE syntax. The WHERE clause specifies which record…