SQL ORDER BY Keyword
The ORDER BY keyword is used to sort the values in Ascending [ASC] or Descending [DESC] order. The default sorting in the ORDER BY keyword is in Ascending Order. To…
SQL Aggregate Functions
These Aggregate functions are used in SQL to do operation on the values of the columns and it returns a single value for the respective column. These Functions are built-in…
Introducing Zoho Analytics Chart Types!
In this blog we are going to discuss Zoho Analytics chart Types. Zoho Analytics is a self-service business intelligence and data analytics program that gives you the ability to analyze your…
SQL NOT Operator
The NOT Operator returns the results when the condition mentioned in the WHERE CLAUSE is not TRUE . The condition is matched and returns those values from the columns that are…
SQL – UPDATE Statement
The UPDATE Query in SQL is used to modify and change the existing values in the columns. The WHERE clause is used with the UPDATE Statement which has a condition…
Get Zoho Analytics for Free!
Zoho Analytics is a self-service business intelligence and data analytics program that gives you the ability to analyze your data with a simple drag-and-drop feature and generate spectacular data visualizations.…
SQL ALTER (RENAME)
Changing the table name to a relevant name can be needed often in the databases. Not only the table but the column names can be also changed as per the…
SQL TOP Clause
The TOP clause in SQL is used to fetch the limited result from the table. It is often used when dealing with larger databases and tables. Syntax of TOP Clause…
SQL ALTER TABLE (ADD/DROP/MODIFY) Command
As discussed in previous articles, we are aware that the changes to a table or column can be done using ALTER TABLE command. The ALTER TABLE can be even used…
SQL CREATE Table
All the clauses and operations in SQL can only be performed in the presence well-designed table. Creating a table involves defining the columns and the datatype for every particular column.…