SQL wildcards can be used when searching for data in a database.
The SQL LIKE clause is used to search for a specified pattern in a column. The SQL LIKE clause is another keyword that is used in the SQL WHERE clause.
The TOP clause is used to specify the number of records to return.
The DELETE statement is used to delete rows in a table.
The UPDATE statement is used to update records in a table.
The INSERT INTO statement is used to insert new records in a table.
The SQL ORDER BY clause defines in what order to return a data set retrieved with a SQL SELECT statement.
The AND & OR operators are used to filter records based on more than one condition.
The SQL WHERE clause is used to select data conditionally, by adding it to already existing SQL SELECT statement.
The SQL DISTINCT clause is used together with the SQL SELECT statement, to return a dataset with unique entries for certain database table column.