Oct 30

SQL wildcards can be used when searching for data in a database.

Continue Reading »

Oct 23

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.

Continue Reading »

Oct 16

The TOP clause is used to specify the number of records to return.

Continue Reading »

Oct 09

The DELETE statement is used to delete rows in a table.

Continue Reading »

Oct 02

The UPDATE statement is used to update records in a table.

Continue Reading »

Sep 25

The INSERT INTO statement is used to insert new records in a table.

Continue Reading »

Sep 18

The SQL ORDER BY clause defines in what order to return a data set retrieved with a SQL SELECT statement.

Continue Reading »

Nov 18

The AND & OR operators are used to filter records based on more than one condition.

Continue Reading »

Nov 11

The SQL WHERE clause is used to select data conditionally, by adding it to already existing SQL SELECT statement.

Continue Reading »

Nov 06

The SQL DISTINCT clause is used together with the SQL SELECT statement, to return a dataset with unique entries for certain database table column.

Continue Reading »