SQL GROUP BY Clause
The GROUP BY clause is used by the SELECT statement to arrange the same values rows in groups. These clauses often use aggregated functions such as AVG(), SUM(), COUNT(), etc.…
How to embed Zoho Reports in your website
In this blog, we are going to discuss How to Embed Zoho Reports in Website. If you have created your reports on Zoho analytics you can easily embed them in…
SQL UNION Operator
The UNION operator is used to combine the results of two or more SELECT statements and return the value without any duplicate values. To use this operator in the SELECT…
SQL RIGHT JOIN
SQL RIGHT JOIN returns all the records from the right table even if there is no match of the records with the right table. If there are no records found…
SQL LEFT JOIN
The LEFT JOIN or LEFT OUTER JOIN is used to retrieve all the records from the Left table (Table A) if there is no match with the Right table (Table…
SQL SELF JOIN
The SELF JOIN is used to join the table to itself, assuming it as two tables. Syntax of SELF JOIN - SELECT A.column_name,B.column_name,... FROM Table A ,Table B WHERE condition…
SQL INNER JOIN
INNER JOIN is the most frequently used join in SQL. These joins are also referred to as EQUIJOIN. It creates a new result set that comprises the matching records of…
SQL Joins
The SQL Joins are used to combine the data from two or more tables on the basis of some related columns of each. Suppose, we want to join Peoples Table…
SQL IN Operator
The IN Operator in SQL is used to return the result that matches the specified values in the WHERE clause. Like the OR Operator, the IN operator works the same.…
How to Use Zoho Analytics User Filter in Reports
In this blog, we will talk about Zoho Analytics User Filter. Zoho Analytics provides two options for applying criteria through the filter. one is a normal Filter that works at…