Skip to main content
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
Search options not deleted user 5226

For issues relating to arranging items into ordered levels.

5 votes
1 answer
4k views

Condition in WHERE vs condition in CONNECT BY

Can anyone explain to me the difference between the following two queries? Even though they seem the same the results are different. select concept.concept_id, concept.PARENT_ID from ebti_thes_conce …
giannis christofakis's user avatar
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 …
giannis christofakis's user avatar