| List: | General Discussion | « Previous MessageNext Message » | |
| From: | Elim PDT | Date: | January 3 2011 4:16am |
| Subject: | where clause | ||
| View as plain text | |||
I have a table with a column pv (int) I want to fetch all the rows r such that (r.pv)+1 is the pv-value of another row. what the sql looks like? thanks
| Thread | ||
|---|---|---|
| • Constructing query to display item count based on increments of time | Pascual Strømsnæs | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Johan De Meersman | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Travis Ard | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Hank | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Johan De Meersman | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Hank | 6 Oct |
| • Re: Constructing query to display item count based on increments of time | Johan De Meersman | 7 Oct |
| • my.ini | Elim PDT | 7 Oct |
| • RE: my.ini | andrew.2.moore | 7 Oct |
| • Re: my.ini | Elim PDT | 7 Oct |
| • where clause | Elim PDT | 3 Jan |