SURVSIMP_RESPONSES_UNIQUE
Columns
| Name | Type | Nullable | Insertable | Updatable | Deletable | Comment |
|---|
| RESPONSE_ID | NUMBER(38) | N | YES | YES | YES | |
| SURVEY_ID | NUMBER(38) | N | YES | YES | YES | |
| SCOPE | VARCHAR2(20.0) | Y | YES | YES | YES | |
| USER_ID | NUMBER(38) | Y | YES | YES | YES | |
| GROUP_ID | NUMBER(38) | Y | YES | YES | YES | |
| TITLE | VARCHAR2(100.0) | Y | YES | YES | YES | |
| SUBMISSION_DATE | DATE | N | YES | YES | YES | |
| IP_ADDRESS | VARCHAR2(50.0) | Y | YES | YES | YES | |
| NOTIFY_ON_COMMENT_P | CHAR(1.0) | Y | YES | YES | YES | |
| PROPOSAL_STATE | VARCHAR2(30.0) | Y | YES | YES | YES | |
Query:
select r1.* from survsimp_responses r1
where r1.response_id=(select max(r2.response_id)
from survsimp_responses r2
where r1.survey_id=r2.survey_id
and r1.user_id=r2.user_id)
Generated by OraSchemaDoc,
(c) Aram Kananov, 2002