0
Not exactly. A query is much more powerful. Essentially it can filter records, but queries can do all sorts of other things that filters cannot do. A filter will reduce down the amount of records you see by apply a condition. You can then scroll through the visible records. A query can do the same thing, but it will give you a list of the records. It can deal with more complex conditions and do many other things like delete records, change values in records, build new tables and many other things that filters cannot do. You would use a filter for simple things, like to filter out all the people working in a particular department, but would use a query for something more complex like to show the people working in a particular department, who are earning a certain amount of pay and have worked in the company for more than a certain amount of years.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is the difference between a filter and a query?
A query is a function designed to output a response. A filter is a restriction designed to weed out irrelevant or unwanted responses.For example, if one were to google information on monks, but not the television show Monk, one might parse the query as: monk -tv -"Tony Shalhoub". The first term would be the query, and the next two terms (each marked with a minus sign) would be the filters.
Difference between SQL and OQL?
in some cease both are the same they use query language but in fact the out puts are very deference
What is a correlated query?
Correlated query has a subquery in it which accesses the column name of a table alias which is outside the subquery.
Why relational algebra is a procedural query language?
The syntax of a query in relational algebra essentially describes the query evaluation algorithm i.e. SELECT WHERE FROM --------------- I don't agree with the above answer. Notice that 'SELECT WHERE FROM' is fragmentary SQL. It does not describe an algorithm, or procedure, for obtaining the desired results. Rather, it describes the characteristics of the desired results and where they might be obtained. In fact, relational algebra is not inherently procedural. It involves closed collections of objects called relations and a set of permitted operations on these objects. Please see the link.
Why do you use Linq over SQL Statements?
The extensibility of the query architecture is used in the LINQ project itself to provide implementations that work over both XML and SQL data. The query operators over XML (LINQ to XML) use an efficient, easy-to-use, in-memory XML facility to provide XPath/XQuery functionality in the host programming language. The query operators over relational data (LINQ to SQL) build on the integration of SQL-based schema definitions into the common language runtime (CLR) type system. This integration provides strong typing over relational data while retaining the expressive power of the relational model and the performance of query evaluation directly in the underlying store.
Which is better a filter or a query in Access?
A query is far more powerful than a filter. It depends on what you want to do. For some simple things a filter will do what you need. A query can do much more sophisticated things.
Multiple conditions in a query or filter are called?
compound criteria
Which is the primary advantage of creating a new query based on an existing query?
It saves time if your new query uses the same fields as the existing query.
Microsoft Access wildcard character removal?
delete 'Like' from the query/filter
What enables you to view data from a table based on a specific criterion?
A query or a filter.
How do you set table filter so it will be applied when the table is opened in access database?
You can save the table with the filter on. It is better to filter through forms or use a query.
How do you create a query in Excel?
You do not really query in excel. If you need to do a lot of queries, use a database. However, you can replicate the effect by using the filter option. Highlight a column and turn on the filter, then select the item you would like to see.
Creates a temporary sub-set of records based on specified criteria.?
A filter or a query.
What is the difference between a filter and a query?
A query is a function designed to output a response. A filter is a restriction designed to weed out irrelevant or unwanted responses.For example, if one were to google information on monks, but not the television show Monk, one might parse the query as: monk -tv -"Tony Shalhoub". The first term would be the query, and the next two terms (each marked with a minus sign) would be the filters.
How do you filter in a database?
While retrieving data from a database, we use SQL (Structured Query Language) language which enables developers to query data. A SQL Select statement which retrieves data from database has a WHERE clause where we can add criteria to filter data based on field values
What is an excel query?
Excel can make queries through using the Filter options. They are not known as queries in Excel, but it is what they can do.
Can write query within the query?
Yes, you can have a query inside a query. That is known as a sub-query.
