Yurttas/PL/DBL/postgres/F/01/SPJ/q11.sql

From ZCubes Wiki
Jump to navigation Jump to search
 1/*
 2REM
 3REM q11.sql
 4REM
 5REM Delete all shipments with quantity greater than 300. 
 6REM
 7*/
 8
 9SELECT current_schema();
10SET search_path to "spj";
11
12DELETE FROM Shipments
13WHERE quantity > 300;