Yurttas/PL/DBL/postgres/F/01/Movies/q10.sql
Revision as of 00:46, 5 November 2013 by MassBot1 (talk | contribs) (Created page with "<syntaxhighlight lang="sql" line start="1" enclose="div">→REM REM q10.sql REM REM Search and find all movies with a REM possesive ('s) in their titles. REM: SELECT cur...")
1/*
2REM
3REM q10.sql
4REM
5REM Search and find all movies with a
6REM possesive ('s) in their titles.
7REM
8*/
9
10SELECT current_schema();
11SET search_path to "movies";
12
13SELECT title
14FROM Movie
15WHERE title LIKE '%''s%';