Apache OpenOffice is the leading open-source office suite software for word processing, spreadsheets, presentations, graphics, databases and more. More Information
In the video I give an explanation how to creating Query using SQL mode.
= , > , < , >= , <= function to searching dataOpenoffice.org base or known as BASE alone is software to manipulate and manage the database. Making data input, as well as manipulating and making reports can be done with this BASE.
Query is an extracting data from a database and displays it for further "processing".
Based on some sites i visited, the query can be interpreted as below for detail
Queries are the database equivalent of filters in a spreadsheet. Just as a filter can limit and reorganize the information displayed in a spreadsheet, so a query limits and reorganizes the information in a database. Either can be an efficient way of finding the information you want, especially when you're dealing with thousands of records. Of course, in the hands of an expert, queries can be far more precise and complicated than a filter, but, if you are using OpenOffice.org Base, then the analogy generally holds true, although queries are slightly more complicated than filters to set up. When saved in Base for long term use, a query becomes a view. Source
Or you can read Wikipedia for more information.
Intermediate
Apache OpenOffice is the leading open source office software for word processing, spreadsheets, presentations, graphics, databases and more. It can be downloaded and used completely free for any purpose. In the video below, I explain how to create a query using SQL view.
some SQL instances that i use to
SELECT * FORM "Employee_tbl"
SELECT "First Name", "Last Name", "Gender" FROM "Employee_tbl" WHERE "ID" = 5 (You can change=to>,<,<=,>=)
SELECT "First Name", "Last Name", "Gender" FROM "Employee_tbl" WHERE "Location" = 'Bireuen'
The Formula :
SELECT ___data you want to display__ FROM __table name__
SELECT ___data you want to display__ FROM __table name__ WHERE __data search area__ = 'data needed'
SELECT ___data you want to display__ FROM __table name__ WHERE __data search area__ BETWEEN __start__ AND __end__
If you want to learn more about OpenOffice, I have uploaded my previous video, you can see below :
