60256b0834
git-svn-id: http://locode01.ad.dom/svn/WEBMIP/trunk@3491 248e525c-4dfb-0310-94bc-949c084e9493
13 lines
317 B
Plaintext
13 lines
317 B
Plaintext
CREATE OR REPLACE VIEW v_current_enquiry_status AS
|
|
SELECT enqu_id
|
|
,event_date
|
|
,enst_code
|
|
FROM (SELECT enqu_id
|
|
,event_date
|
|
,enst_code
|
|
,id
|
|
,MAX(id) over(PARTITION BY enqu_id) AS max_id
|
|
FROM enquiry_events)
|
|
WHERE id = max_id
|
|
/
|