The following operators can be used to better focus your queries.
( ) , AND, OR, NOT, W/#
? single char wildcard, not at start
* multi char wildcard, not at start
(Cat? OR feline) AND NOT dog?
Cat? W/5 behavior
(Cat? OR feline) AND traits
Cat AND charact*
This guide provides a more detailed description of the syntax that is supported along with examples.
This search box also supports the look-up of an IP.com Digital Signature (also referred to as Fingerprint); enter the 72-, 48-, or 32-character code to retrieve details of the associated file or submission.
Concept Search - What can I type?
For a concept search, you can enter phrases, sentences, or full paragraphs in English. For example, copy and paste the abstract of a patent application or paragraphs from an article.
Concept search eliminates the need for complex Boolean syntax to inform retrieval. Our Semantic Gist engine uses advanced cognitive semantic analysis to extract the meaning of data. This reduces the chances of missing valuable information, that may result from traditional keyword searching.
A method is described which prevents the user from having to know the SQL syntax and semantics for a Group By clause.
English (United States)
This text was extracted from a PDF file.
100% of the total text.
Page 1 of 1
Implied Grouping When Summary Function Selected In Prompted Query
A method is described which prevents the user from having to know the SQL
syntax and semantics for a Group By clause.
In previous prompted query proposals, users were required to know about
the GROUP BY clause of the SQL SELECT statement. Users have difficulty
understanding the usage of this clause as well as the syntax and semantics.
This method provides a mechanism for an Implied group by
clause. When a summary function is selected in Prompted Query,
grouping is automatically implied, and any columns selected are
assumed to be grouping columns. Grouping is implied if:
- There is selection of a summary function, either alone or as
part of a larger expression (except if the expression is the argument
of a group function).
- A summary function is used in a row condition. This is
necessary because it is possible that a user will want to group
without selecting a group function, e.g.,
SELECT DEPT FROM STAFF HAVING AVERAGE (SALARY) > 10000
The user may not explicitly specify (or delete) grouping. If all summary
functions are deleted, grouping is no longer implied.