Search Results
| Search type | Search syntax |
|---|---|
| Tags | [tag] |
| Exact | "words here" |
| Author |
user:1234 user:me (yours) |
| Score |
score:3 (3+) score:0 (none) |
| Answers |
answers:3 (3+) answers:0 (none) isaccepted:yes hasaccepted:no inquestion:1234 |
| Views | views:250 |
| Code | code:"if (foo != bar)" |
| Sections |
title:apples body:"apples oranges" |
| URL | url:"*.example.com" |
| Saves | in:saves |
| Status |
closed:yes duplicate:no migrated:no wiki:no |
| Types |
is:question is:answer |
| Exclude |
-[tag] -apples |
| For more details on advanced search visit our help page | |
Results tagged with where
Search options not deleted
user 5226
The `WHERE` clause is used to specify criterion for retrieval or modification of rows from objects in a database.
5
votes
1
answer
4k
views
Condition in WHERE vs condition in CONNECT BY
In the second one, the exists predicate is moved from the connect by clause to the where clause.
select concept.concept_id, concept.PARENT_ID
from ebti_thes_concept_v concept
where exists (..) …
5
votes
Accepted
Condition in WHERE vs condition in CONNECT BY
After reading the documentation, I came to the following conclusions.
One difference between the two queries is that the first query has two condition in the connect by , in order to identify a relat …