Datadictionary OpenWave 3.1.32
Previous topic Chapter index Next topic

View: vwmilzwemlabanalyselaatstedrie

 

 

Schema

public

 

Owner

waveuser005

 

Descriptions

Haalt de laatste drie labanalysedata per object op

 

Fields

Name

Data type

Description

dnkeymilinrichtingen

integer

 

dnkeyobject

integer

 

dnkeylabanalysekop

integer

 

ddmonsterdatum

timestamp

 

 

Rules

Name

Event

Instead

Condition

Description

_RETURN

SELECT

 

 

 

Indices

There are no indices for table vwmilzwemlabanalyselaatstedrie

 

Definition

CREATE VIEW public.vwmilzwemlabanalyselaatstedrie (
   dnkeymilinrichtingen,
   dnkeyobject,
   dnkeylabanalysekop,
   ddmonsterdatum)
AS
SELECT
rankfilter.dnkeymilinrichtingen,
   rankfilter.dnkeyobject,
   rankfilter.dnkeylabanalysekop,
   rankfilter.ddmonsterdatum
FROM (
   SELECT kop.dnkeymilinrichtingen,
           kop.dnkeyobject,
           kop.dnkeylabanalysekop,
           kop.ddmonsterdatum,
           rank() OVER (PARTITION BY kop.dnkeyobject
   ORDER BY kop.ddmonsterdatum DESC) AS rank
   FROM vwmilzwemlabanalysekop kop
   ) rankfilter
WHERE rankfilter.rank < 4;

COMMENT ON VIEW public.vwmilzwemlabanalyselaatstedrie
IS 'Haalt de laatste drie labanalysedata per object op';

This file was generated with SQL Manager for PostgreSQL (www.pgsqlmanager.com) at 2-5-2025 13:49
Previous topic Chapter index Next topic