Category Archives: SQL

Learn SQL , SQL Tutorials , Learn DBMS

Learn SQL , SQL Tutorials , Learn DBMS. What is SQL Database and how to create sql database and table.

How to use SQL TOP Clause

SQL TOP Clause - The TOP Clause is used to return a TOP N number records from a table. The TOP clause is used to specify the number of record to return.

How to use SQL WHERE Clause

Learn SQL WHERE Clause - The SQL WHERE Clause is used to specify the condition while make action like Select, Update and Delete operation on Database Table.

How to use SQL ORDER BY Clause

SQL ORDER BY Clause - is used to sort the records in ascending or descending order, based on one or more columns. By default records sort order is ascending order.

SQL AND & OR Operators

SQL AND & OR Operators. The AND Operator - The AND operator is used to returns those records whose value must be match with all the condition WHERE.The OR Operator - The OR Operator is used to returns those records whose value match with any value in WHERE condition.

SQL SELECT DISTINCT Clause

SQL SELECT DISTINCT Clause. SQL DISTINCT Clause : The sql Distinct clause is used to remove duplicate records from the result of sql select statement.

SQL BETWEEN Operator

SQL BETWEEN Operator. SQL BETWEEN Operator - The SQL BETWEEN operator is used to returns records match between two values in WHERE Condition.The range of value should be text, numbers or dates.

SQL IN Operator, SQL NOT IN Operator

SQL IN Operator, SQL NOT IN Operator. SQL IN Operator - The SQL IN operator used to select column with more than one value in WHERE condition. The IN operator allow us to specify the more than one value in Where condition.

SQL LIKE Operator

SQL LIKE Operator. SQL LIKE Operator - The SQL LIKE operator is used to returns all rows from a table whose column value match a specific pattern.