SE-3

SQL QUERY HOW TO USE IT IN ZOHO PLATFROM

 

This is 21 century. We are living an era called information era. All information stores in digital device that understand o or 1 binary digit. All Information is store in name called database. Creating your own database and running SQL query itself was a challenged. But when ZOHO come into the picture it makes our life easy. It not only provides us creating your own online database and query but also make it very simple.

There are some steps to follow create and run this data base.

Go to the website and create an your own user account in www.db.zoho.com

Then create a database by any of the four options displayed i.e. import via excel sheet, enter data right away, create database from template, create blank database. Then name the tables (in my case EMPLOYEE & DEPARTMENT).

If you need to change some characteristic of Table you can do it after creating it.

Now run SQL query according to your need.

According to my database three SQL queries were run and thus three query tables (views) were generated namely JOIN, AVERAGE QUERY & CONDITIONS. But the main issue is ‘How to run a query? Earlier if you want to run and use SQL database you need to have SQL database knowledge. But ZOHO platform make this complicated system to simple. Now it becomes easy to create, delete update and query of SQL database. Here one can write query functions and can also have SQL functions (table and column name) from the box besides query writing area.

There are three query tables one is for joining the tables and the syntax is

 

Select “Employee_id”,”First Name”,”Last Name”, “Salary”,”Commision”, “Salary”

+”Commision”*”Salary” from”EMP” where “Depart_ment” = ‘SALES

Here

EMP=Employee

DEPT=Department

SQL query for getting average salary of the firm’s employee. This is in average value of salary in Employee table.

Syntax for this SQL query is

Select AVG(“Salary”) from”EMP”;

Select max(“Salary”) from”EMP”;

Select SUM(“Salary”) from”EMP”;

 

 

Here it generate the average salary of employee from employee table

This gives the average of the values of the column chosen. This is a multiple row function. Accordingly there are other functions also such as sum, max, etc.

SQL query for various restrictions such as OR, AND, wild cards is to obtain constrained view.

Next are

Select “Employee_id” , “First Name” ,”Last Name” from “EMP” where (“First Name”=’Abu’ OR “First Name”=’Faizan’ or “First Name” like ‘D%’)

This gives the customized view of the database. Here according to the command the three respective columns are selected. Which are encompassed through restrictions that are elements of first name are equal to two of the identified elements of first names? Means only those rows are selected which have identified elements in them. Also column name1 which is ‘name’ is subjected to constrain that name should start with ‘A’.

Select “Employee_id”, “Last Name”,”First Name”, “Location” from EMP”, “DEPT” where “EMP”.”Employee_id” = “DEPT”.”E_id”

In this SQL query three commend very important and it uses are most of time the command is ‘select’, ‘delete’ and ‘update ’.

Limitation of db.zoho.com is that only SELECT query can run.

To see Query tables please go to the link mention below:

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004401&STANDALONE=true

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004310&STANDALONE=true

 

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004963&STANDALONE=true

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004932&STANDALONE=true

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004876&STANDALONE=true

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004760&STANDALONE=true

 

http://db.zoho.com:80/ZDBDataSheetView.cc?OBJID=24430000000004635&STANDALONE=true