SQL Practical Guide

Search

SNOMED CT Document Library

    Loading...

Page tree

Versions Compared

Old Version 1

changes.mady.by.user David Markwell

Saved on

compared with

New Version 2

changes.mady.by.user David Markwell

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Warning

For example, in the following query the check for the active status is included in the nested query. This will lead to the most recent active version of each component being selected. The result of this query will therefore include an earlier active version of any component that is now inactive. A similar issue may also occur with other criteria

Footnote Macro

For more details about potential snapshot view query errors see C.3. Common Mistakes with Snapshot Generation.

.

Code Block
languagesql
titleGeneral Snapshot Query - With Error Due to Added Condition in Nested Query
select * from full_tableName tbl
	where tbl.effectiveTime = (select max(sub.effectiveTime) from full_tableName sub 
								where sub.id = tbl.id and sub.active=1);



...