You can rename a database using ALTER DATABASE statement. Limitations and restrictions of renaming a database 1. Database cannot be renamed to an existing database… [Read More]

SQL Data type defines the values that a column can accept, for example if a column of the table has an int data type, then… [Read More]

This SQL tutorial is design for beginners as well as advanced professionals. Each tutorial is started from basic level so a SQL beginner will be… [Read More]

SQL AVG() function returns the average of values of a numeric column in a table. AVG() Syntax SELECT AVG(column_name) FROM table_name WHERE condition; SQL AVG()… [Read More]

SQL SUM() function returns the total sum of values of a numeric column in a table. SUM() function Syntax SELECT SUM(column_name) FROM table_name WHERE condition;… [Read More]

SQL MIN() & MAX() functions are used to find the lowest value and largest value of a column respectively. MIN(column_name): It returns the lowest value… [Read More]

SQL DELETE statement is used to permanently delete existing records (rows) from the table. This statement can be used to delete one or more records… [Read More]

The UPDATE statement in SQL is used to update records in the table. We can modify one or multiple records (rows) in table using UPDATE… [Read More]

In SQL Where clause tutorial, we learned how to use comparison operators such as =, <, > etc in where clause for conditions. However when… [Read More]

SQL SELECT AS is used to assign temporary names to table or column name or both. This is known as creating Alias in SQL. In… [Read More]