Changes between Version 1 and Version 2 of SortingResults

Timestamp:

09/04/18 15:31:22 (6 years ago)

Author:

alisdair

Comment:

--

SortingResults

@@ -36 +36 @@
 2014-09-19T01:00:36}{ 2014-09-19T01:00:35 2014-09-19T01:00:36}
 }}}
+The sample query is a follows
+{{{
+SELECT
+   date_obs,
+   date_obs as date_end,
+   t_rec_index,
+   fsn,
+   recnum,
+   sunum,
+   wave as wavemin,
+   wave as wavemax,
+   clusterid,
+   fileid
+FROM vso.%s
+WHERE 1=1 %%s
+  AND t_rec_index IN (
+    SELECT hashed.d
+    FROM (
+      SELECT MIN(t_rec_index) as d,
+        FLOOR( ( EXTRACT(EPOCH FROM date_obs) - EXTRACT(EPOCH FROM CAST(? AS TIMESTAMP) ) ) / ? ) AS hash
+      FROM vso.%s
+      WHERE 1=1 %%s
+      GROUP BY hash
+    ) AS hashed
+  )
+%%s => where clause ; %s => table name
+}}}
+
 **Why does this happen?** \\
 \\