@prefix dbo:	<http://dbpedia.org/ontology/> .
<http://ja.dbpedia.org/resource/SELECT_(SQL)>	dbo:wikiPageWikiLink	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570>	dbo:wikiPageWikiLink	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .
@prefix rdfs:	<http://www.w3.org/2000/01/rdf-schema#> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	rdfs:label	"\u7A93\u95A2\u6570 (SQL)"@ja ;
	rdfs:comment	"SQL \u306B\u304A\u3044\u3066\u3001\u7A93\u95A2\u6570\uFF08\u307E\u3069\u304B\u3093\u3059\u3046\uFF09\u3082\u3057\u304F\u306F\u30A6\u30A3\u30F3\u30C9\u30A6\u95A2\u6570 (\u30A6\u30A3\u30F3\u30C9\u30A6\u304B\u3093\u3059\u3046\u3001\u82F1: window function) \u306F\u7D50\u679C\u30BB\u30C3\u30C8\u3092\u90E8\u5206\u7684\u306B\u5207\u308A\u51FA\u3057\u305F\u9818\u57DF\u306B\u96C6\u7D04\u95A2\u6570\u3092\u9069\u7528\u3067\u304D\u308B\u3001\u62E1\u5F35\u3055\u308C\u305F SELECT \u30B9\u30C6\u30FC\u30C8\u30E1\u30F3\u30C8\u3067\u3042\u308B\u3002 \u4EE5\u964D\u306E\u6A19\u6E96SQL\u3067\u898F\u5B9A\u3055\u308C\u3066\u3044\u308B\u3002\u5206\u6790\u95A2\u6570\u3084OLAP\u6A5F\u80FD\u3068\u547C\u3070\u308C\u308B\u5834\u5408\u3082\u3042\u308B\u3002 \u4EE5\u4E0B\u306E\u4F8B\u306F\u3001\u540C\u3058 city \u3054\u3068\u306B\u3001\u305D\u306E\u4EBA\u53E3\u3092\u96C6\u8A08\u3057\u3066\u3044\u308B\u3002 sum(population) OVER( PARTITION BY city ) \u96C6\u7D04\u3092\u884C\u3046\u9818\u57DF\u306F OVER \u53E5\u306B\u3088\u308A\u5236\u5FA1\u3067\u304D\u308B\u3002\u4EE5\u4E0B\u306E\u69CB\u6587\u3092\u6301\u3061\u3001\u7D50\u679C\u30BB\u30C3\u30C8\u306E\u5206\u5272\u3068\u9806\u5E8F\u3092\u5236\u5FA1\u3067\u304D\u308B\u3002ORDER BY \u53E5\u306F row_number \u95A2\u6570\u306E\u3088\u3046\u306A\u9806\u5E8F\u306E\u5F71\u97FF\u3092\u53D7\u3051\u308B\u51E6\u7406\u306B\u5BFE\u3057\u3066\u4F7F\u7528\u3059\u308B\u3002 :: = OVER ( [ PARTITION BY , ... ] [ ORDER BY ] )"@ja .
@prefix dct:	<http://purl.org/dc/terms/> .
@prefix ns3:	<http://ja.dbpedia.org/resource/Category:> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	dct:subject	ns3:SQL ,
		<http://ja.dbpedia.org/resource/Category:\u30C7\u30FC\u30BF\u30D9\u30FC\u30B9> ;
	dbo:wikiPageID	1995455 ;
	dbo:wikiPageRevisionID	79811749 .
@prefix dbpedia-ja:	<http://ja.dbpedia.org/resource/> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	dbo:wikiPageWikiLink	dbpedia-ja:DB2 ,
		dbpedia-ja:PostgreSQL ,
		<http://ja.dbpedia.org/resource/SELECT_(SQL)> ,
		dbpedia-ja:Microsoft_SQL_Server ,
		<http://ja.dbpedia.org/resource/\u5206\u6790> ,
		<http://ja.dbpedia.org/resource/SQL:2003> ,
		dbpedia-ja:Oracle_Database ,
		ns3:SQL ,
		<http://ja.dbpedia.org/resource/Category:\u30C7\u30FC\u30BF\u30D9\u30FC\u30B9> ,
		dbpedia-ja:OLAP ,
		dbpedia-ja:SQL ;
	dbo:wikiPageExternalLink	<http://msdn.microsoft.com/ja-jp/library/ms189461.aspx> ,
		<http://www.postgresql.jp/document/current/html/functions-window.html> ,
		<http://publib.boulder.ibm.com/infocenter/db2luw/v9r7/index.jsp%3Ftopic=/com.ibm.db2.luw.sql.ref.doc/doc/r0023461.html> ,
		<http://otndnld.oracle.co.jp/document/products/oracle11g/111/doc_dvd/server.111/E05763-01/analysis.htm> .
@prefix prop-en:	<http://ja.dbpedia.org/property/> .
@prefix template-en:	<http://ja.dbpedia.org/resource/Template:> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	prop-en:wikiPageUsesTemplate	template-en:No_footnotes ,
		template-en:Otheruses ,
		template-en:Database ,
		template-en:Computer-stub ,
		template-en:Lang-en-short ;
	dbo:wikiPageInterLanguageLink	<http://dbpedia.org/resource/Select_(SQL)> ;
	dbo:abstract	"SQL \u306B\u304A\u3044\u3066\u3001\u7A93\u95A2\u6570\uFF08\u307E\u3069\u304B\u3093\u3059\u3046\uFF09\u3082\u3057\u304F\u306F\u30A6\u30A3\u30F3\u30C9\u30A6\u95A2\u6570 (\u30A6\u30A3\u30F3\u30C9\u30A6\u304B\u3093\u3059\u3046\u3001\u82F1: window function) \u306F\u7D50\u679C\u30BB\u30C3\u30C8\u3092\u90E8\u5206\u7684\u306B\u5207\u308A\u51FA\u3057\u305F\u9818\u57DF\u306B\u96C6\u7D04\u95A2\u6570\u3092\u9069\u7528\u3067\u304D\u308B\u3001\u62E1\u5F35\u3055\u308C\u305F SELECT \u30B9\u30C6\u30FC\u30C8\u30E1\u30F3\u30C8\u3067\u3042\u308B\u3002 \u4EE5\u964D\u306E\u6A19\u6E96SQL\u3067\u898F\u5B9A\u3055\u308C\u3066\u3044\u308B\u3002\u5206\u6790\u95A2\u6570\u3084OLAP\u6A5F\u80FD\u3068\u547C\u3070\u308C\u308B\u5834\u5408\u3082\u3042\u308B\u3002 \u4EE5\u4E0B\u306E\u4F8B\u306F\u3001\u540C\u3058 city \u3054\u3068\u306B\u3001\u305D\u306E\u4EBA\u53E3\u3092\u96C6\u8A08\u3057\u3066\u3044\u308B\u3002 sum(population) OVER( PARTITION BY city ) \u96C6\u7D04\u3092\u884C\u3046\u9818\u57DF\u306F OVER \u53E5\u306B\u3088\u308A\u5236\u5FA1\u3067\u304D\u308B\u3002\u4EE5\u4E0B\u306E\u69CB\u6587\u3092\u6301\u3061\u3001\u7D50\u679C\u30BB\u30C3\u30C8\u306E\u5206\u5272\u3068\u9806\u5E8F\u3092\u5236\u5FA1\u3067\u304D\u308B\u3002ORDER BY \u53E5\u306F row_number \u95A2\u6570\u306E\u3088\u3046\u306A\u9806\u5E8F\u306E\u5F71\u97FF\u3092\u53D7\u3051\u308B\u51E6\u7406\u306B\u5BFE\u3057\u3066\u4F7F\u7528\u3059\u308B\u3002 :: = OVER ( [ PARTITION BY , ... ] [ ORDER BY ] )"@ja .
@prefix xsd:	<http://www.w3.org/2001/XMLSchema#> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	dbo:wikiPageLength	"1261"^^xsd:nonNegativeInteger .
@prefix prov:	<http://www.w3.org/ns/prov#> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	prov:wasDerivedFrom	<http://ja.wikipedia.org/wiki/\u7A93\u95A2\u6570_(SQL)?oldid=79811749&ns=0> .
@prefix foaf:	<http://xmlns.com/foaf/0.1/> .
<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)>	foaf:isPrimaryTopicOf	<http://ja.wikipedia.org/wiki/\u7A93\u95A2\u6570_(SQL)> .
@prefix owl:	<http://www.w3.org/2002/07/owl#> .
@prefix dbpedia-wikidata:	<http://wikidata.dbpedia.org/resource/> .
dbpedia-wikidata:Q24898611	owl:sameAs	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .
<http://ja.dbpedia.org/resource/\u30A6\u30A3\u30F3\u30C9\u30A6\u95A2\u6570>	dbo:wikiPageWikiLink	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> ;
	dbo:wikiPageRedirects	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .
<http://ja.wikipedia.org/wiki/\u7A93\u95A2\u6570_(SQL)>	foaf:primaryTopic	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .
@prefix rdf:	<http://www.w3.org/1999/02/22-rdf-syntax-ns#> .
<http://ja.dbpedia.org/data/\u7A93\u95A2\u6570_(SQL).ntriples>	rdf:type	foaf:Document ;
	foaf:primaryTopic	<http://ja.dbpedia.org/resource/\u7A93\u95A2\u6570_(SQL)> .