steps:
1. goto http://db.zoho.com/
2. login
3. make a table and save by clicking on "enter data straight away"
4. to make the second table click on the drop down list from "new" and select "new table"
5. once the tables are made goto the same drop down list from "new" and click on "new query table"
6. enter your commands here and get the output
following are the queries and their results:
1. joining the two tables with "employee id" being the pk:
2. to view all employees with salary greater than 20,000:
3. to view all employees from the sales department:
1 comment:
no authority to access data .. otherwise neat
Post a Comment