SQL

Running a Query

 

Hello Friends this is as simple as playing a game like ‘Moto GP’. Just read the below given Points and you will be fluent in running queries.

·         Go to http://db.Zoho.com.

·         Now enter your ID and create your database .You can either copy paste the data or yourself create it in the template.

·         Now, in my case I have created 2 data base with names like ‘Employee’ and ‘Department’, you can give any of the random names.

·           Now I want to run a Query to join these 2 databases, in order to do that i have to run a simple query like select name, employee……. from employee database and from department database and put a equal sign in between only if there’s something common in the two databases or one is attribute is a primary key 1 database and foreign key to the another.

·         My second Query was to do the avg. of the salaries of the persons working in a company ’xyz’ , here I selected  Avg. function from the SQL function  given in the insert column and ran the query it gave me the avg. of the salaries of all the 19 persons working in the company.

·         My third Query was to select people who were either have a employee designation as ‘Clerk or were having their age greater then 30, here I selected the attributes required for the final table and gave an or option in the query got the final table.

So, now you can see what a miracle this SQL language is, easy to understand and fast to work with……

Work on it and enjoy……..

ALSO VISIT:

• http://db.zoho.com/ZDBDataSheetView.cc?DBID=19235000000003491&OBJID=19235000000003668

To view my tables