A database query is similar to a command that can be used to perform a specific function on a database table. Some common types of queries are:
Any thing that has to do with database is a query lanquage. As in query the data to retrieve whatever you are looking for.
Literally "query" is just another word for "question". So right up there is an example. In SQL, a query would be something like SELECT NAME FROM EMP WHERE DEPARTMENT = 'MARKETING';
Select query is a DRL. DRL stands for Data retrieval language. Example select * from table_name;
Select query is a DRL. DRL stands for Data retrieval language. Example select * from table_name;
QBE stands for Query by Example.
http://ww.google.com
A query by example is where you fill in data that in effect acts like a sample of what you want the query to retrieve. So if you have a set of data of employees and want to show ones that work in a particular department, you would type the name of the department into the query to correspond to the field that shows the department. So in the query, you would have chosen your fields, and in the criteria under the department field you might type something like "Sales", indicating that you want records that have "Sales" in the department field. What you type in acts as an example of the data you want to get. You could use lots of criteria in different ways and build more complex queries, but still using a query by example approach.
pls soon answer my query....
You would need to exclude the unwanted values in the where clause of the query, for example;select * from InvoiceLines where InvoiceValue 0
The * symbol is a universal wildcard symbol. In the Access Query By Example Design Pane, the * represents all fields in the table or query.
Query is an instruction given to Database engine to retrieve the results. Example: Select EmployeeName From tblEmployees Where EmployeeID = 123; This is a sample query to retrieve the Name of a particular employee from the set of records saved already.
The standard query language for relational databases, as adopted by the American National Standards Institute (ANSI), is SQL, which is generally understood to be an abbreviation for "structured query language."