Help for this page

Select Code to Download


  1. or download this
    SQL ERROR: Bad set function before FROM clause.
    
    ...
    Execution ERROR: No command found!.
    
    $VAR1 = undef;
    
  2. or download this
        my $sth = $dbh->prepare("SELECT * FROM results WHERE 1=0");
        $sth->execute;
    ...
          . join(', ', map { "avg($_) \n" } @cols )
          . ' FROM results';
        my $avgsHashRef = $dbh->selectrow_hashref($avgSQL);
    
  3. or download this
    Execution ERROR: Can't use AVG on a string! called from ./runsql3.sql 
    +at 24.
    
    ...
    , avg(ERWWSQLWEBProcessorTotalPCTProcessorTime)
     FROM results"] at ./runsql3.sql line 24.
    $VAR1 = undef;