SQL – DROP Database Table of content The SQL DROP DATABASE statement is used to delete an existing database along with all the data such as tables, views, indexes, stored procedures, and constraints. SQL DROP Database Statement Following are the important points to remember before you delete an existing database − Make sure you have […]
Category Archives: sql
SQL – Aggregate Functions In general, aggregation is a consideration of a collection of objects that are bound together as a single entity. SQL provides a set of aggregate functions that perform operations on all the entities of the column of a table considering them as a single unit. Following are the SQL aggregate functions […]
SQL – Numeric Functions SQL numeric functions are used primarily for numeric manipulation and/or mathematical calculations. The following table details the numeric functions − Sr.No. Function & Description 1 Returns the absolute value of numeric expression. 2 Returns the arccosine of numeric expression. Returns NULL if the value is not in the range -1 to […]