Example: Using the WHERE Clause (AVRO)
Using the table Myavrotable09:
/*determine if any sale included a bicycle*/ SELECT 'TRUE' FROM Myavrotable09 WHERE 'bicycle' = ANY(avroFile.."Item_Name");
Result:
> TRUE
/*determine if any sale was for more than $50*/ SELECT 'TRUE' FROM Myavrotable09 WHERE 50 < ANY(avroFile.."Total_Price");
Result:
> TRUE
/*determine if ALL sales were for more than $50*/ SELECT 'TRUE' FROM Myavrotable09 WHERE 50 < ALL(avroFile.."Total_Price");
Result:
> TRUE
Example: Using the WHERE Clause (CSV)
Using the table MyCSVtable09:
/*determine if any sale included a basketball*/ SELECT 'TRUE' FROM MyCSVtable09 WHERE 'Basketball' = ANY(csvFile.."ItemName");
Result:
> TRUE
/*determine if any sale was for more than $15*/ SELECT 'TRUE' FROM MyCSVtable09 WHERE 15 < ANY(csvFile.."Total_Price");
Result:
> TRUE
/*determine if ALL sales were for more than $50*/ SELECT 'TRUE' FROM MyCSVtable09 WHERE 50 < ALL(csvFile.."Total_Price");
Result:
*** No rows found