SQL UPDATE Statement : SQL UPDATE statement is used to modify the existing records in a table. UPDATE Syntax UPDATE table_name SET column1 = value1, column2 = value2, … WHERE condition; Note: Be careful
Read moreCategory: SQL
SQL DELETE Statement
SQL DELETE Statement : SQL DELETE statement is used to delete existing records in a table. DELETE Syntax DELETE FROM table_name WHERE condition; Note: Be careful when deleting records
Read moreSQL TOP, LIMIT or ROWNUM Clause
SQL TOP, LIMIT or ROWNUM Clause : SQL TOP, LIMIT or ROWNUM Clause are explained with examples. The SQL SELECT TOP Clause The SELECT TOP clause
Read moreSQL MIN() and MAX() Functions
SQL MIN() and MAX() Functions : SQL MIN() and MAX() Functions are used to find the high value and low value respectively. The MIN() function returns the
Read moreSQL COUNT(), AVG() and SUM()Functions
SQL COUNT(), AVG() and SUM() Functions : SQL COUNT(), AVG() and SUM() Functions are explained one by one. The COUNT() function returns the number of rows
Read moreSQL LIKE Operator
SQL LIKE Operator : SQL LIKE operator is used in a WHERE clause to search for a specified pattern in a column. There are two wildcards
Read moreSQL Wildcards
SQL Wildcards : SQL wildcards characters is used to substitute any other character(s) in a string. Wildcard characters are used with the SQL LIKE operator. The LIKE
Read moreSQL IN Operator
SQL IN Operator : SQL IN operator allows you to specify multiple values in a WHERE clause. The IN operator is a shorthand for multiple
Read moreSQL BETWEEN Operator
SQL BETWEEN Operator : SQL BETWEEN operator selects values within a given range. The values can be numbers, text, or dates. The BETWEEN operator is
Read moreSQL Aliases
SQL Aliases : SQL aliases are used to give a table, or a column in a table, a temporary name. Aliases are often used to
Read more