SQL COUNT() Function
Jun 27,92The SQL COUNT() function can be used in two ways: COUNT(*) – counts the number of rows in a table …
Read MoreSQL AVG() Function
Jun 27,92The AVG() function is used to return the average value of a specific numeric column in the table. The syntax: …
Read MoreSQL Functions
Jun 27,92Just like any other computer language, SQL supports the use of functions to manipulate with data. Function is a simple …
Read MoreSQL ALTER TABLE statement
Jun 27,92The ALTER TABLE statement is used to update database table definitions. For example, to add a column in a table, …
Read MoreSQL DROP statement
Jun 26,92The SQL DROP statement permanently removes database objects such as tables, views, or indexes. To drop a database, use the …
Read MoreSQL Constraints
Jun 26,92SQL Constraints are rules which regulates how database data is inserted or manipulated. They are usually used to prevent a user from storing …
Read More