End of preview
Want to read all 2 pages? Upload your study docs or become a member.
Unformatted text preview:-- Listing 14-19: Using ST_Intersection() to show where SELECT water.fullname AS waterway, roads.rttyp, @@ -241,7 +241,7 @@ ORDER BY count(*) DESC; SELECT stabr, count(*) FROM pls_fy2014_pupld14a GROUP BY stabr ORDER BY count(stabr) DESC; ORDER BY count(*) DESC;-- Listing 8-10: GROUP BY with count() on the stabr and statad Note: CLONE With this script: git clone -n cd sql-server-samples git config core.sparsecheckout true echo samples/features/*| out-file -append -encoding ascii .git/info/sparse- checkout echo samples/demos/*| out-file -append -encoding ascii .git/info/sparse- checkout git checkout