SQL WHERE Clause : SQL WHERE Clause is used to filter records and to extract only those records that fulfill a specified condition. The WHERE clause is
Read moreAuthor: selva
SQL AND, OR and NOT Operators
SQL AND, OR and NOT Operators : SQL AND, OR and NOT Operators are used to filter records. The AND and OR operators are used to
Read moreSQL ORDER BY Keyword
SQL ORDER BY Keyword : SQL ORDER BY keyword is used to sort the result-set in ascending or descending order. The ORDER BY keyword is used
Read moreSQL INSERT INTO Statement
SQL INSERT INTO Statement : SQL INSERT INTO statement is used to insert new records in a table. INSERT INTO Syntax It is possible to write
Read moreSQL NULL Values
SQL NULL Values : SQL NULL Values is a field with no value. What is a NULL Value? A field with a NULL value is a
Read moreSQL UPDATE Statement
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 moreSQL 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 more