Matches in SemOpenAlex for { <https://semopenalex.org/work/W3023544006> ?p ?o ?g. }
Showing items 1 to 72 of
72
with 100 items per page.
- W3023544006 abstract "Publisher SummaryThis chapter extends the syntax of the SELECT statement by examining WHERE clause filtering, conditional comparisons, and logical operators. Filtering is a process of retrieving a subset of the rows retrieved by the SELECT statement. EXISTS checks for membership as IN does with a few differences. EXISTS allows a correlation and index matching between a calling query and a subquery. Like the IN condition, EXISTS implies set membership and allows multiple-row returning subqueries. Logical operators in Oracle SQL are AND, OR, and NOT. They work to concatenate multiple conditional expressions together. Precedence rules apply in that expressions are evaluated from left to right, unless overridden by parenthesized sections. NOT has higher precedence than AND, followed by OR. The Top-N query feature introduced in Oracle Database 9i provides the capability to retrieve small sections of a large table without having to write an application or use expensive third-party tools to dig into voluminous or copious amounts of data. A WHERE clause can allow the use of specific indexes both for reading data and for applying inherent index sorts." @default.
- W3023544006 created "2020-05-13" @default.
- W3023544006 creator A5069852778 @default.
- W3023544006 creator A5085682373 @default.
- W3023544006 date "2005-01-01" @default.
- W3023544006 modified "2023-09-25" @default.
- W3023544006 title "Filtering Rows" @default.
- W3023544006 doi "https://doi.org/10.1016/b978-155558323-1/50007-3" @default.
- W3023544006 hasPublicationYear "2005" @default.
- W3023544006 type Work @default.
- W3023544006 sameAs 3023544006 @default.
- W3023544006 citedByCount "0" @default.
- W3023544006 crossrefType "book-chapter" @default.
- W3023544006 hasAuthorship W3023544006A5069852778 @default.
- W3023544006 hasAuthorship W3023544006A5085682373 @default.
- W3023544006 hasConcept C105795698 @default.
- W3023544006 hasConcept C118615104 @default.
- W3023544006 hasConcept C124101348 @default.
- W3023544006 hasConcept C135598885 @default.
- W3023544006 hasConcept C136979486 @default.
- W3023544006 hasConcept C138885662 @default.
- W3023544006 hasConcept C165064840 @default.
- W3023544006 hasConcept C177264268 @default.
- W3023544006 hasConcept C199360897 @default.
- W3023544006 hasConcept C204321447 @default.
- W3023544006 hasConcept C2776401178 @default.
- W3023544006 hasConcept C2777026412 @default.
- W3023544006 hasConcept C2777382242 @default.
- W3023544006 hasConcept C33923547 @default.
- W3023544006 hasConcept C41008148 @default.
- W3023544006 hasConcept C41895202 @default.
- W3023544006 hasConcept C45235069 @default.
- W3023544006 hasConcept C510870499 @default.
- W3023544006 hasConcept C55166926 @default.
- W3023544006 hasConcept C60048249 @default.
- W3023544006 hasConceptScore W3023544006C105795698 @default.
- W3023544006 hasConceptScore W3023544006C118615104 @default.
- W3023544006 hasConceptScore W3023544006C124101348 @default.
- W3023544006 hasConceptScore W3023544006C135598885 @default.
- W3023544006 hasConceptScore W3023544006C136979486 @default.
- W3023544006 hasConceptScore W3023544006C138885662 @default.
- W3023544006 hasConceptScore W3023544006C165064840 @default.
- W3023544006 hasConceptScore W3023544006C177264268 @default.
- W3023544006 hasConceptScore W3023544006C199360897 @default.
- W3023544006 hasConceptScore W3023544006C204321447 @default.
- W3023544006 hasConceptScore W3023544006C2776401178 @default.
- W3023544006 hasConceptScore W3023544006C2777026412 @default.
- W3023544006 hasConceptScore W3023544006C2777382242 @default.
- W3023544006 hasConceptScore W3023544006C33923547 @default.
- W3023544006 hasConceptScore W3023544006C41008148 @default.
- W3023544006 hasConceptScore W3023544006C41895202 @default.
- W3023544006 hasConceptScore W3023544006C45235069 @default.
- W3023544006 hasConceptScore W3023544006C510870499 @default.
- W3023544006 hasConceptScore W3023544006C55166926 @default.
- W3023544006 hasConceptScore W3023544006C60048249 @default.
- W3023544006 hasLocation W30235440061 @default.
- W3023544006 hasOpenAccess W3023544006 @default.
- W3023544006 hasPrimaryLocation W30235440061 @default.
- W3023544006 hasRelatedWork W2016707928 @default.
- W3023544006 hasRelatedWork W2053072337 @default.
- W3023544006 hasRelatedWork W2084834553 @default.
- W3023544006 hasRelatedWork W2094296275 @default.
- W3023544006 hasRelatedWork W2119781861 @default.
- W3023544006 hasRelatedWork W2326523184 @default.
- W3023544006 hasRelatedWork W2352131886 @default.
- W3023544006 hasRelatedWork W2620942864 @default.
- W3023544006 hasRelatedWork W3133613038 @default.
- W3023544006 hasRelatedWork W4241765764 @default.
- W3023544006 isParatext "false" @default.
- W3023544006 isRetracted "false" @default.
- W3023544006 magId "3023544006" @default.
- W3023544006 workType "book-chapter" @default.