Top Articles in Tutorials


tutorial image

Tutorial on SQL Joins

  SQL Joins are mainly used to relate information present in different tables.   A Join statement is a kind of condition in the SQL query, capable to retrieve rows or fetch records from multiple tables. A SQL Join condition is typically used in the SQL WHERE Clause of select, update, delete statements. Syntax of … Read More

tutorial image

Tutorial on SQL INSERT INTO Command

  The INSERT INTO statement is used to insert new records in a table. In SQL, there are fundamentally two ways to INSERT data into a table: One is to insert it one row at a time, the approach is to insert multiple rows at a time.In this given section, we are going to look … Read More

tutorial image

Tutorial on SQL WHERE Clause

  The WHERE clause is mainly used to filter the result set depending on certain conditions or situation.   The syntax for using WHERE in the SELECT statement is given below:   SELECT “column_name” FROM “table_name” WHERE “condition”;   “Condition” might include a single comparison clause (known as simple condition) or multiple comparison clauses, when … Read More

tutorial image

Tutorial on SQL LIKE statement

  LIKE is a keyword which is used in the WHERE clause. Fundamentally, LIKE permits you to perform a search depending on a pattern instead of specifying exactly what is expected (as in IN) or spell out a range (as in BETWEEN).   The syntax is shown below:   SELECT “column_name” FROM “table_name” WHERE “column_name” … Read More

tutorial image

Tutorial on SQL DISTINCT statement

  The “SELECT” keyword permit user to grab all available information from a column (or columns) on a table. This may implies that there will be redundancies.   In a situation where we only wish to select each DISTINCT element, this is easy to perform in SQL. All we require to do is to add … Read More

tutorial image

Tutorial on SQL Group By Command

  This is an aggregate function. This SQL statement is used of a case when we wish to calculate the total sales for each store. We need to perform two things: First, we need to ensure we select the store name as well as total sales. And second, we need to ensure that all the … Read More

tutorial image

Tutorial on SQL HAVING Command

  In this tutorial we are going to learn, how to limit the output depending on the corresponding sum (or any other aggregate functions). For instance, we might want to view only the stores having sales over $1,500. Rather than using the WHERE clause in the SQL statement.   We might need to use the … Read More

tutorial image

Tutorial on SQL AS Command

  In the SQL Alias command section, we observed that the syntax for using table and column aliases is as shown below:   SELECT “TableAlias”.”ColumnName” “ColumnAlias” FROM “TableName” “TableAlias”;   The keyword “AS” is mainly used to allot an alias to the column or a table. It is inserted in between the column name and … Read More

tutorial image

Tutorial on SQL Alias Command

  In this tutorial we are going to focus on the use of aliases. There are two kinds of aliases that are used most often: column alias and table alias.   In brief, column aliases exist to help organizing output. We can envision cases where the column heading might be complicated (particularly if it involves … Read More

tutorial image

A tutorial on passing parameter values back out from a stored procedure

  In the given previous topic we observed how to pass parameters into a stored procedure; however, another way is to pass parameter values back out from a stored procedure.   One way of doing this is that you call another stored procedure that does not return any data, however returns parameter values cab be … Read More