Relative Content

Tag Archive for querying

Create query statement from a resultset of a previous query

This is the original table: “multiactualusetest”
| TAXDECNUM | ACTUALUSE | TAXABLE | MARKETVALUE | ASSESSEDVALUE |
| ————- | ————- | ————- | ————- | ————- |
| G-508659 | S | Y | 182000 | 0 |
| G-508659 | C | Y | 166600 | 16660 |
| G-508659 | A | Y | 9768 | 3910 |
| G-508659 | R | Y | 140000 | 9800 |
| G-432185 | R | Y | 65000 | 4550 |
| G-432185 | A | Y | 9041.09 | 3620 |
| E-008926 | A | Y | 20346.12 | 940 |
| E-008926 | A | Y | 7360 | 540 |
| E-008926 | R | Y | 27000 | 5500 |
| G-508847 | R | Y | 21500 | 1510 |