SQL (Structured Query Language) – ORDER BY Clause
The SQL ORDER BY clause is used to sort the data in ascending or descending order, based on one or more columns. Some databases sort the query …
SQL Tutorials
SQL (Structured Query Language) – TOP, LIMIT or ROWNUM Clause
The SQL TOP clause is used to fetch a TOP N number or X percent records from a table. Note − All the databases do not support the …
SQL (Structured Query Language) – LIKE Clause
The SQL LIKE clause is used to compare a value to similar values using wildcard operators. There are two wildcards used in conjunction with the LIKE operator. …
SQL (Structured Query Language) – DELETE Query
The SQL DELETE Query is used to delete the existing records from a table. You can use the WHERE clause with a DELETE query to …
SQL (Structured Query Language) – UPDATE Query
The SQL UPDATE Query is used to modify the existing records in a table. You can use the WHERE clause with the UPDATE query to update the …
SQL (Structured Query Language) – AND and OR Conjunctive Operators
The SQL AND & OR operators are used to combine multiple conditions to narrow data in an SQL statement. These two operators are called as the conjunctive operators. These …
SQL (Structured Query Language) – WHERE Clause
The SQL WHERE clause is used to specify a condition while fetching the data from a single table or by joining with multiple tables. If the given …
