Project

General

Profile

« Previous | Next » 

Revision 1159

Added by Aaron Marcuse-Kubitza almost 13 years ago

SALVIAS verifications: Use count(DISTINCT) instead of nested SELECT DISTINCT

View differences:

inputs/SALVIAS/verify.ref
54 54 
___
55 55 
# locations
56 56 
count
57 
7053
57 
7052
58 58 
___
59 59 
# location events
60 60 
count
inputs/SALVIAS/verify.ref.sql
15 15 
;
16 16 

  		




  17
  17
  
    
SELECT '# locations' AS ___;


  		




  18
  
  
    
SELECT count(*) AS count


  		




  19
  
  
    
FROM


  		




  20
  
  
    
(


  		




  21
  
  
    
    SELECT DISTINCT LatDec, LongDec FROM plotMetadata


  		




  22
  
  
    
) locationcoords


  		




  
  18
  
    
SELECT count(DISTINCT LatDec, LongDec) AS count FROM plotMetadata


  		




  23
  19
  
    
;


  		




  24
  20
  
    

  		




  25
  21
  
    
SELECT '# location events' AS ___;


  		












Also available in:  Unified diff