Archive

Category Archives for "SQL"

SQL BETWEEN Operator

SQL BETWEEN Operator is used to filter rows based on range of values in specified column. These values can be numbers, text or dates. Rows can be retrieved not in between the range of values specified column.

Continue reading

SQL LIKE Operator

SQL LIKE Operator is used in WHERE Clause of SQL statement, to search for specific pattern in column. And the pattern we can place it in different formats. Here I’ll provide different types of formats that you can use in SQL LIKE Operator.

Continue reading

SQL SELECT LIMIT, TOP, ROWNUM

SQL SELECT LIMIT, TOP, ROWNUM clauses are used to limit the number of retrieved records. SQL SELECT LIMIT, TOP, ROWNUM clauses are very useful to databases having lot of records, this clause helps to return limited number of results instead of all records. For large databases it takes lot of time to retrieve all the […]

Continue reading

SQL ORDER BY

SQL ORDER BY is used to filter results by ascending or descending order in SQL SELECT statements. We can add ORDER BY right after the table name or after WHERE clause in the SQL statement.

Continue reading

SQL WHERE Clause

SQL WHERE Clause is used to retrieve specific records which matches the column names and values in WHERE clause. This SQL WHERE clause is used in any SQL statement, either it is SELECT, UPDATE, DELETE statements.

Continue reading

SQL DISTINCT

SQL DISTINCT function is used in SELECT statements, it is used to retrieve the results without duplicate values. That means SQL DISTINCT function will retrieve different values. Sample code for SQL DISTINCT is :

Continue reading

SQL INSERT

The SQL INSERT statement allows you to insert a single record or multiple records into a table. This SQL statement can be used on any database either it is MySQL or MsSQL. The syntax for the SQL INSERT statement is:

Continue reading

SQL SELECT

The SQL SELECT statement allows you to retrieve records from one or more tables in your SQL database. For SQL SELECT statements can be used with WHERE clauses and also using relationship by joining tables. The result is stored in a result table, called the result-set.

Continue reading