GROUP BY clauseとは 意味・読み方・使い方

'group' - the GROUP BY clause'having' - the HAVING clause発音を聞く 例文帳に追加

'group' - GROUP BY 句'having' - HAVING 句 - PEAR

'order' - the ORDER BY clause The values of the 'select', 'from', 'where', 'group', 'having', and 'order' elements are strings that contain the text of correspondingclause of the desired SQL statement, excluding the keywords SELECT, FROM, WHERE, GROUP BY, HAVING, or ORDER, respectively.発音を聞く 例文帳に追加

'order' - ORDER BY 句'select'、'from'、'where'、'group'、'having' そして 'order'の各要素の値は、SQL 文のそれぞれの句に対応する文字列となります。 ただし、それぞれのキーワード SELECT、FROM、WHERE、GROUP BY、HAVINGそして ORDER はのぞきます。 - PEAR

A suite is a group of statements controlled by a clause. A suite can be one or more semicolon-separated simple statements on the same line as the header, following the header'scolon, or it can be one or more indented statements on subsequentlines.例文帳に追加

スイートは、ヘッダのコロンの後ろにセミコロンで区切られた一つまたはそれ以上の単純文を並べるか、ヘッダ行後のインデントされた文の集まりです。 - Python

(5) The provisions of the preceding paragraphs shall apply mutatis mutandis to cases where Regulated Securities issued by a company fall under any of the categories specified in the items of paragraph (1). In this case, the term "excluding Regulated Securities" in the main clause of paragraph (1) shall be deemed to be replaced with "limited to Regulated Securities"; the term "the company shall" in the main clause of paragraph (1) shall be deemed to be replaced with "the company (if said Securities are so specified by a Cabinet Office Ordinance, excluding persons specified by a Cabinet Office Ordinance) shall"; the terms "the trade name of the company, financial conditions of the Corporate Group to which the company belongs and of the company, other important matters concerning the company's business" in the main clause of paragraph (1) shall be deemed to be replaced with "financial conditions of asset investment or other similar businesses conducted by the company, other important matters concerning the company's assets"; the term "for each business year" in the main clause of paragraph (1) shall be deemed to be replaced with "for each of the periods of time specified by a Cabinet Office Ordinance for the Regulated Securities (hereinafter referred to as the "Specified Period" in this Article)"; the term "that business year" in the main clause of paragraph (1) shall be deemed to be replaced with "that Specified Period"; the part "the Securities issued by the company fall under the category of Securities specified in item (iii) below (limited to share certificates and other Securities specified by a Cabinet Order) and the numbers of holders of the Securities on the last day of that business year and on the last days of the business years that began within four years before the day on which that business year began are fewer than the number calculated pursuant to the provisions of a Cabinet Order, if the Prime Minister approves pursuant to the provisions of a Cabinet Office Ordinance that even if the company does not submit Annual Securities Reports, the public interest or protection of investors would not be impaired (limited to the company for which five years have already passed after the end of the Starting Year of Report Submission (meaning the business year that includes the day on which the main clause of Article 4(1) or (2) or the main clause of Article 23-8(1) or (2) became applicable to the Public Offering or Secondary Distribution of the Securities, or, the latest one of such business years); where the Securities issued by the company fall under the category of Securities specified in item (iv) below" in the proviso to paragraph (1) shall be deemed to be replaced with "the Regulated Securities issued by the company fall under the category of Securities specified in item (iv) below"; the part "or if the number of holders of the Securities on the last day of that business year is fewer than the number specified by a Cabinet Order; and" in the proviso to paragraph (1) shall be deemed to be replaced with "; and"; the part "share certificates, Rights in Securities Investment Business, etc. that shall be deemed as Securities under Article 2(2)" in item (iv) of paragraph (1) shall be deemed to be replaced with "Rights in Securities Investment Business, etc. that shall be deemed as Securities under Article 2(2)"; the part "if the number of its holders on the last day of that business year or on the last day of any of the business years that began within four years before the day on which that business year began is not less than the number specified by a Cabinet Order (or, in case of Rights in Securities Investment Business, etc. that shall be deemed as Securities under Article 2(2), the number of its holders on the last day of that business year is not less than the number specified by a Cabinet Order)" in item (iv) of paragraph (1) shall be deemed to be replaced with "if the number of its holders on the last day of the Specified Period is not less than the number specified by a Cabinet Order"; the term "issued Securities" in paragraph (2) shall be deemed to be replaced with "issued Regulated Securities"; the term "Securities issued" in paragraph (3) shall be deemed to be replaced with "Regulated Securities issued"; the term "a company" in paragraph (3) shall be deemed to be replaced with "a company (if said Regulated Securities are Securities so specified by a Cabinet Office Ordinance, excluding persons specified by a Cabinet Office Ordinance)"; the term "the main clause of paragraph (1)" in paragraph (3) shall be deemed to be replaced with "the main clause of paragraph (1) as applied mutatis mutandis pursuant to paragraph (5)"; the term "business year" in paragraph (3) shall be deemed to be replaced with "Specified Period"; the term "the day on which the Securities came" in paragraph (3) shall be deemed to be replaced with "the day on which the Regulated Securities came"; and any other necessary technical replacement of terms shall be specified by a Cabinet Order.発音を聞く 例文帳に追加

５　前各項の規定は、特定有価証券が第一項各号に掲げる有価証券のいずれかに該当する場合について準用する。この場合において、同項本文中「有価証券の発行者である会社」とあるのは「有価証券の発行者である会社（内閣府令で定める有価証券については、内閣府令で定める者を除く。）」と、「特定有価証券を除く」とあるのは「特定有価証券に限る」と、「事業年度ごと」とあるのは「当該特定有価証券につき、内閣府令で定める期間（以下この条において「特定期間」という。）ごと」と、「当該会社の商号、当該会社の属する企業集団及び当該会社の経理の状況その他事業」とあるのは「当該会社が行う資産の運用その他これに類似する事業に係る資産の経理の状況その他資産」と、「当該事業年度」とあるのは「当該特定期間」と、同項ただし書中「当該有価証券が第三号に掲げる有価証券（株券その他の政令で定める有価証券に限る。）に該当する場合においてその発行者である会社（報告書提出開始年度（当該有価証券の募集又は売出しにつき第四条第一項本文若しくは第二項本文又は第二十三条の八第一項本文若しくは第二項の規定の適用を受けることとなつた日の属する事業年度をいい、当該報告書提出開始年度が複数あるときは、その直近のものをいう。）終了後五年を経過している場合に該当する会社に限る。）の当該事業年度の末日及び当該事業年度の開始の日前四年以内に開始した事業年度すべての末日における当該有価証券の所有者の数が政令で定めるところにより計算した数に満たない場合であつて有価証券報告書を提出しなくても公益又は投資者保護に欠けることがないものとして内閣府令で定めるところにより内閣総理大臣の承認を受けたとき、当該有価証券が第四号」とあるのは「当該特定有価証券が第四号」と、「及び当該事業年度の末日における当該有価証券の所有者の数が政令で定める数に満たないとき、並びに」とあるのは「及び」と、同項第四号中「株券、第二条第二項の規定により有価証券とみなされる有価証券投資事業権利等」とあるのは「第二条第二項の規定により有価証券とみなされる有価証券投資事業権利等」と、「当該事業年度又は当該事業年度の開始の日前四年以内に開始した事業年度のいずれかの末日におけるその所有者の数が政令で定める数以上（当該有価証券が同項の規定により有価証券とみなされる有価証券投資事業権利等である場合にあつては、当該事業年度の末日におけるその所有者の数が政令で定める数以上）」とあるのは「当該特定期間の末日におけるその所有者の数が政令で定める数以上」と、第二項中「有価証券の」とあるのは「特定有価証券の」と、第三項中「第一項本文」とあるのは「第五項において準用する第一項本文」と、「発行者」とあるのは「発行者（内閣府令で定める有価証券については、内閣府令で定める者を除く。）」と、「有価証券が」とあるのは「特定有価証券が」と、「その該当することとなつた日」とあるのは「当該特定有価証券につき、その該当することとなつた日」と、「事業年度」とあるのは「特定期間」と読み替えるものとするほか、必要な技術的読替えは、政令で定める。 - 日本法令外国語訳データベースシステム

Notwithstanding that a resident of a Contracting State may not be a qualified person, that resident shall be entitled to the benefits granted by the provisions of paragraph 3 of Article 10, subparagraph (c), (d) or (e) of paragraph 3 of Article 11, Article 12, paragraph 6 of Article 13 or Article 22 with respect to an item of income described in those subparagraphs, paragraphs or Articles derived from the other Contracting State if: (i) that resident functions as a headquarters company for a multinational corporate group; (ii) the item of income derived from that other Contracting State is derived in connection with, or is incidental to, the trade or business activity referred to in clause (ii) of subparagraph (b); and (iii) that resident satisfies any other specified conditions in those subparagraphs, paragraphs or Articles for the obtaining of such benefits.発音を聞く 例文帳に追加

一方の締約国の居住者は、適格者に該当しない場合においても、他方の締約国内から取得する第十条３、第十一条３(c)、(d)若しくは(e)、第十二条、第十三条６又は前条に定める所得に関し、次の(i)から(iii)までに掲げる要件を満たすときは、これらの規定により認められる特典を受ける権利を有する。(i)当該居住者が多国籍企業集団の本拠である法人として機能すること。(ii)当該所得がに(b)(ii)規定する営業又は事業の活動に関連し、又は付随して取得されるものであること。(iii)当該居住者がこれらの規定により認められる特典を受けるためにこれらの規定に規定する要件を満たすこと。 - 財務省

6. a) Notwithstanding that a resident of a Contracting State may not be a qualified person, that resident shall be entitled to the benefits granted by the provisions of paragraph 3 of Article 10, paragraph 3 of Article 11 or Article 12, 13 or 20 with respect to an item of income described in those paragraphs or Articles derived from the other Contracting State if: (i) that resident functions as a headquarters company for a multinational corporate group; (ii) the item of income derived from that other Contracting State either is derived in connection with, or is incidental to, the business referred to in clause (ii) ofsubparagraph b); and (iii) that resident satisfies any other specified conditions in those paragraphs or Articles for the obtaining of such benefits.例文帳に追加

６(a)一方の締約国の居住者は、適格者に該当しない場合においても、他方の締約国内から取得する第十条３、第十一条３、第十二条、第十三条又は前条に定める所得に関し、次のからまでに掲げる要件を満たすときは、これらの規定により認められる特典を受ける権利を有する。(i)当該居住者が多国籍企業集団の本拠である法人として機能すること。(ii)当該所得が(b)(ii)に規定する事業に関連し、又は付随して取得されるものであること。(iii)当該居住者がこれらの規定により認められる特典を受けるためにこれらの規定に規定する要件を満たすこと。 - 財務省

(5) The provisions of paragraph (1) to the preceding paragraph shall apply mutatis mutandis to cases where the Securities for which the notification set forth in paragraph (1) is made are Regulated Securities. In this case, the terms "excluding a Public Offering or Secondary Distribution of Securities" and "said Securities (excluding Regulated Securities; hereinafter the same shall apply in this paragraph to paragraph (iv))" in paragraph (1) shall be deemed to be replaced with "limited to a Public Offering or Secondary Distribution of Securities" and "said Securities," respectively; the terms "Trade name of the company, financial conditions of the Corporate Group (meaning the group consisting of the company and other persons (limited to companies or other organizations specified by a Cabinet Office Ordinance) who satisfies the requirements specified by a Cabinet Office Ordinance as those for being regarded as having a close relationship with the company, including the requirement that the company holds the majority of voting rights of the person who is a company; the same shall apply hereinafter) to which the company belongs and of the company, other important matters concerning the company's business" in item (ii) of said paragraph shall be deemed to be replaced with "Financial conditions of asset investment or other similar businesses conducted by the company, other important matters concerning the company's assets"; the term "a Public Offering or Secondary Distribution of Securities" in paragraph (2) shall be deemed to be replaced with "a Public Offering or Secondary Distribution of Regulated Securities"; the term "Securities falling under any of the categories" in item (i) of said paragraph shall be deemed to be replaced with "Regulated Securities falling under any of the categories of Securities"; the term "Public Offering or Secondary Distribution of Securities" in item (ii) of said paragraph shall be deemed to be replaced with "Public Offering or Secondary Distribution of Regulated Securities"; the term "the main clause of Article 24(1)," "Article 24-4-7(1) or (2)," "the matters set forth in Article 24-4-7(1)" and "the matters set forth in Article 24-5(1)" in item (iii) of said paragraph shall be deemed to be replaced with "the main clause of Article 24(1) as applied mutatis mutandis pursuant to Article 24(5)," "Article 24-4-7(1) or (2) as applied mutatis mutandis pursuant to Article 24-4-7(3)," "the matters set forth in Article 24-4-7(1) as applied mutatis mutandis pursuant to Article 24-4-7(3)" and "the matters set forth in Article 24-5(1) as applied mutatis mutandis pursuant to Article 24-5(3) "; and any other necessary technical replacement of terms shall be specified by a Cabinet Order.発音を聞く 例文帳に追加

５　第一項から前項までの規定は、当該有価証券が特定有価証券である場合について準用する。この場合において、第一項中「有価証券の募集及び売出しを除く」とあるのは「有価証券の募集又は売出しに限る」と、「当該有価証券（特定有価証券を除く。以下この項から第四項までにおいて同じ。）」とあるのは「当該特定有価証券」と、同項第二号中「当該会社の商号、当該会社の属する企業集団（当該会社及び当該会社が他の会社の議決権の過半数を所有していることその他の当該会社と密接な関係を有する者として内閣府令で定める要件に該当する者（内閣府令で定める会社その他の団体に限る。）の集団をいう。以下同じ。）及び当該会社の経理の状況その他事業」とあるのは「当該会社が行う資産の運用その他これに類似する事業に係る資産の経理の状況その他資産」と、第二項中「有価証券の募集又は売出しのうち」とあるのは「特定有価証券に係る有価証券の募集又は売出しのうち」と、同項第一号中「有価証券の」とあるのは「特定有価証券の」と、同項第二号中「有価証券の募集又は売出し」とあるのは「特定有価証券に係る有価証券の募集又は売出し」と、同項第三号中「同項本文」とあるのは「第二十四条第五項において準用する同条第一項本文」と、「第二十四条の四の七第一項若しくは第二項」とあるのは「第二十四条の四の七第三項において準用する同条第一項若しくは第二項」と、「第二十四条の四の七第一項に規定する事項」とあるのは「第二十四条の四の七第三項において準用する同条第一項に規定する事項」と、「第二十四条の五第一項に規定する事項」とあるのは「第二十四条の五第三項において準用する同条第一項に規定する事項」と読み替えるものとするほか、必要な技術的読替えは、政令で定める。 - 日本法令外国語訳データベースシステム