The SQL LIKE query is used to evaluate a value to related values using wildcard operators. You could use two wildcards for conjunction with the LIKE operator…..
The DELETE query is used to delete records from table….
The SQL UPDATE Query is used to adjust the existing records in a table. WHERE phrase also used with UPDATE query to update selected rows…
The ORDER BY is used to arrange the result-set by columns. The ORDER BY arranges the records in ascending (ASC) order. For descending order, you could use the DESC beside ASC….
The AND & OR operators are used to sort out records based on more than one situation. If both the first condition AND the second situation are true then you will get records….
The SQL INSERT INTO query is used to append new rows of information to a table in the database…..
The WHERE statement is used to filter records that complete a particular standard…
The SELECT DISTINCT query is used to return just different values. Sometimes In database/tables, a column may hold lots of duplicate values and you want to list the different values….
SQL uses lots of different data types like: numeric, date & time, and string types…..