http://oracle.se-free.com/dml/06_max.html

IP: 157.7.107.132 AS7506 INTERQ GMO Internet,Inc, JP
Title: ORACLE/オラクルSQLリファレンス(MAX)
This domain was created at 2006-02-09 00:26:25
Domain registrant name is Whois Privacy Protection Service by MuuMuuDomain
Domain registrant org is Whois Privacy Protection Service by MuuMuuDomain
Domain registrant country is JP
IP location is JP
Timeline shows the history of Website activity such as Domain creation, Contents modification.
Timestamp Action
2006/02/09 00:26:25
Domain creation date
2010/08/08 05:40:11 http://oracle.se-free.com/dml/06_max.html
2011/11/12 09:34:42 http://oracle.se-free.com/img/banner.jpg
2015/10/09 12:39:08 http://j1.ax.xrea.com/l.j?id=100263949
2015/10/20 07:57:24 http://j1.ax.xrea.com/ts.gif
2021/01/10 07:36:44 Domain updated date
2022/02/09 00:26:25 Domain expiration date
Whois information can be help to identify owner of domain, however it's often hidden by Domain Privacy service.
Name Whois Privacy Protection Service by MuuMuuDomain
Organization Whois Privacy Protection Service by MuuMuuDomain
Registrar GMO INTERNET, INC.
Country JP
City Fukuoka-shi
Address 2-7-21 Tenjin Chuo-kuTenjin Prime 8F
Expiration date 2022-02-09 00:26:25
Creation date 2006-02-09 00:26:25
Updated date 2021-01-10 07:36:44
Code URL Type Size Timestamp
200
oracle.se-free.com
Document
text/html
12844
2021-06-11 07:55:42
Sun, 08 Aug 2010 05:40:11 GMT
200
j1.ax.xrea.com
Script
application/javascript
12954
2021-06-11 07:55:42
Fri, 09 Oct 2015 12:39:08 GMT
200
oracle.se-free.com
Image
image/jpeg
32800
2021-06-11 07:55:43
Sat, 12 Nov 2011 09:34:42 GMT
200
j1.ax.xrea.com
Image
image/gif
634
2021-06-11 07:55:43
Tue, 20 Oct 2015 07:57:24 GMT
200
j1.ax.xrea.com
Image
text/html
762
2021-06-11 07:55:43
200
pagead2.googlesyndication.com
Script
text/javascript
93171
2021-06-11 07:55:43
200
adservice.google.co.jp
Script
application/javascript
156
2021-06-11 07:57:50
200
www.googletagservices.com
Script
text/javascript
74866
2021-06-11 07:57:50
200
adservice.google.com
Script
application/javascript
156
2021-06-11 07:57:51

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html xmlns="http://www.w3.org/1999/xhtml"><head>
<meta name="GENERATOR" content="IBM WebSphere Studio Homepage Builder Version 10.0.0.0 for Windows" />
<meta http-equiv="Content-Type" content="text/html; charset=Shift_JIS" />
<meta http-equiv="Content-Style-Type" content="text/css" />
<title>ORACLE/オラクルSQLリファレンス(MAX)</title>
<meta name="robots" content="index,follow" />
<meta name="ROBOTS" content="ALL" />
<meta name="description" content="サンプルコード付きの実践的なORACLE SQLのリファレンスを公開しています。" />
<meta name="keywords" content="オラクル,SQL,ORACLE,関数,平均,最高,MAX,AVG,MIN" />
<style type="text/css">
<!--
TD{
  line-height : 150%;
}
TD { font-size: 10pt; } 
-->
</style>
<meta http-equiv="origin-trial" content="A+b/H0b8RPXNaJgaNFpO0YOFuGK6myDQXlwnJB3SwzvNMfcndat4DZYMrP4ClJIzYWo3/yP2S+8FTZ/lpqbPAAEAAABueyJvcmlnaW4iOiJodHRwczovL2ltYXNkay5nb29nbGVhcGlzLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzVGhpcmRQYXJ0eSI6dHJ1ZX0=" /><meta http-equiv="origin-trial" content="A9ZgbRtm4pU3oZiuNzOsKcC8ppFSZdcjP2qYcdQrFKVzkmiWH1kdYY1Mi9x7G8+PS8HV9Ha9Cz0gaMdKsiVZIgMAAAB7eyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AxL6oBxcpn5rQDPKSAs+d0oxNyJYq2/4esBUh3Yx5z8QfcLu+AU8iFCXYRcr/CEEfDnkxxLTsvXPJFQBxHfvkgMAAACBeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="A9KPtG5kl3oLTk21xqynDPGQ5t18bSOpwt0w6kGa6dEWbuwjpffmdUpR3W+faZDubGT+KIk2do0BX2ca16x8qAcAAACBeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="A3HucHUo1oW9s+9kIKz8mLkbcmdaj5lxt3eiIMp1Nh49dkkBlg1Fhg4Fd/r0vL69mRRA36YutI9P/lJUfL8csQoAAACFeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="A0OysezhLoCRYomumeYlubLurZTCmsjTb087OvtCy95jNM65cfEsbajrJnhaGwiTxhz38ZZbm+UhUwQuXfVPTg0AAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="AxoOxdZQmIoA1WeAPDixRAeWDdgs7ZtVFfH2y19ziTgD1iaHE5ZGz2UdSjubkWvob9C5PrjUfkWi4ZSLgWk3Xg8AAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="A7+rMYR5onPnACrz+niKSeFdH3xw1IyHo2AZSHmxrofRk9w4HcQPMYcpBUKu6OQ6zsdxf4m/vqa6tG6Na4OLpAQAAAB4eyJvcmlnaW4iOiJodHRwczovL2ltYXNkay5nb29nbGVhcGlzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AwfG8hAcHnPa/kJ1Co0EvG/K0F9l1s2JZGiDLt2mhC3QI5Fh4qmsmSwrWObZFbRC9ieDaSLU6lHRxhGUF/i9sgoAAACBeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AwQ7dCmHkvR6FuOFxAuNnktYSQrGbL4dF+eBkrwNLALc69Wr//PnO1yzns3pjUoCaYbKHtVcnng2hU+8OUm0PAYAAACHeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AysVDPGQTLD/Scn78x4mLwB1tMfje5jwUpAAzGRpWsr1NzoN7MTFhT3ClmImi2svDZA7V6nWGIV8YTPsSRTe0wYAAACHeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><link rel="preload" href="https://adservice.google.co.jp/adsid/integrator.js?domain=oracle.se-free.com" as="script" /><script src="https://pagead2.googlesyndication.com/pagead/js/adsbygoogle.js"></script><script src="https://www.googletagservices.com/activeview/js/current/osd.js"></script><script type="text/javascript" src="https://adservice.google.co.jp/adsid/integrator.js?domain=oracle.se-free.com"></script><link rel="preload" href="https://adservice.google.com/adsid/integrator.js?domain=oracle.se-free.com" as="script" /><script type="text/javascript" src="https://adservice.google.com/adsid/integrator.js?domain=oracle.se-free.com"></script><meta http-equiv="origin-trial" content="A+b/H0b8RPXNaJgaNFpO0YOFuGK6myDQXlwnJB3SwzvNMfcndat4DZYMrP4ClJIzYWo3/yP2S+8FTZ/lpqbPAAEAAABueyJvcmlnaW4iOiJodHRwczovL2ltYXNkay5nb29nbGVhcGlzLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzVGhpcmRQYXJ0eSI6dHJ1ZX0=" /><meta http-equiv="origin-trial" content="A9ZgbRtm4pU3oZiuNzOsKcC8ppFSZdcjP2qYcdQrFKVzkmiWH1kdYY1Mi9x7G8+PS8HV9Ha9Cz0gaMdKsiVZIgMAAAB7eyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AxL6oBxcpn5rQDPKSAs+d0oxNyJYq2/4esBUh3Yx5z8QfcLu+AU8iFCXYRcr/CEEfDnkxxLTsvXPJFQBxHfvkgMAAACBeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="A9KPtG5kl3oLTk21xqynDPGQ5t18bSOpwt0w6kGa6dEWbuwjpffmdUpR3W+faZDubGT+KIk2do0BX2ca16x8qAcAAACBeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiVHJ1c3RUb2tlbnMiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="A3HucHUo1oW9s+9kIKz8mLkbcmdaj5lxt3eiIMp1Nh49dkkBlg1Fhg4Fd/r0vL69mRRA36YutI9P/lJUfL8csQoAAACFeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="A0OysezhLoCRYomumeYlubLurZTCmsjTb087OvtCy95jNM65cfEsbajrJnhaGwiTxhz38ZZbm+UhUwQuXfVPTg0AAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="AxoOxdZQmIoA1WeAPDixRAeWDdgs7ZtVFfH2y19ziTgD1iaHE5ZGz2UdSjubkWvob9C5PrjUfkWi4ZSLgWk3Xg8AAACLeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1N1YmRvbWFpbiI6dHJ1ZSwiaXNUaGlyZFBhcnR5Ijp0cnVlfQ==" /><meta http-equiv="origin-trial" content="A7+rMYR5onPnACrz+niKSeFdH3xw1IyHo2AZSHmxrofRk9w4HcQPMYcpBUKu6OQ6zsdxf4m/vqa6tG6Na4OLpAQAAAB4eyJvcmlnaW4iOiJodHRwczovL2ltYXNkay5nb29nbGVhcGlzLmNvbTo0NDMiLCJmZWF0dXJlIjoiQ29udmVyc2lvbk1lYXN1cmVtZW50IiwiZXhwaXJ5IjoxNjI2MjIwNzk5LCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AwfG8hAcHnPa/kJ1Co0EvG/K0F9l1s2JZGiDLt2mhC3QI5Fh4qmsmSwrWObZFbRC9ieDaSLU6lHRxhGUF/i9sgoAAACBeyJvcmlnaW4iOiJodHRwczovL2RvdWJsZWNsaWNrLm5ldDo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AwQ7dCmHkvR6FuOFxAuNnktYSQrGbL4dF+eBkrwNLALc69Wr//PnO1yzns3pjUoCaYbKHtVcnng2hU+8OUm0PAYAAACHeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXN5bmRpY2F0aW9uLmNvbTo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><meta http-equiv="origin-trial" content="AysVDPGQTLD/Scn78x4mLwB1tMfje5jwUpAAzGRpWsr1NzoN7MTFhT3ClmImi2svDZA7V6nWGIV8YTPsSRTe0wYAAACHeyJvcmlnaW4iOiJodHRwczovL2dvb2dsZXRhZ3NlcnZpY2VzLmNvbTo0NDMiLCJmZWF0dXJlIjoiSW50ZXJlc3RDb2hvcnRBUEkiLCJleHBpcnkiOjE2MjYyMjA3OTksImlzU3ViZG9tYWluIjp0cnVlLCJpc1RoaXJkUGFydHkiOnRydWV9" /><link rel="preload" href="https://adservice.google.co.jp/adsid/integrator.js?domain=oracle.se-free.com" as="script" /><script type="text/javascript" src="https://adservice.google.co.jp/adsid/integrator.js?domain=oracle.se-free.com"></script><link rel="preload" href="https://adservice.google.com/adsid/integrator.js?domain=oracle.se-free.com" as="script" /><script type="text/javascript" src="https://adservice.google.com/adsid/integrator.js?domain=oracle.se-free.com"></script></head>
<body><script src="https://partner.googleadservices.com/gampad/cookie.js?domain=oracle.se-free.com&callback=_gfp_s_&client=ca-pub-3981107707611067"></script><script src="https://pagead2.googlesyndication.com/pagead/js/r20210607/r20190131/show_ads_impl.js" id="google_shimpl"></script><script language="JAVASCRIPT"><!--
var ID="100263949-06_max";
var AD=4;
var FRAME=0;
// --></script>
<script language="JAVASCRIPT" src="http://j1.ax.xrea.com/l.j?id=100263949"></script><div style="top:591;left:720;position:absolute;z-index:2;visibility:hidden;" id="axL2" onmouseover="sL('axL1')" onmouseout="sA()"><a href="http://wj.ax.xrea.com/c.f?id=100263949" target="_blank"><img style="width:80px;height:9px;" width="80" height="9" src="http://j1.ax.xrea.com/x.gif" border="0" /></a></div><div style="top:591;left:720;position:absolute;z-index:2;visibility:hidden;" id="axL1"><a href="http://wj.ax.xrea.com/c.f?id=100263949" target="_blank"><img style="width:80px;height:9px;" width="80" height="9" src="http://j1.ax.xrea.com/ts.gif" border="0" /></a></div><script src="http://wj.ax.xrea.com/l56.f?&x=454950774&id=100263949&url=http://oracle.se-free.com/dml/06_max.html&rf=&sw=800&sh=600&cd=24&je=&pf=0&cc=&bt=%EF%BC%AF%EF%BC%B2%EF%BC%A1%EF%BC%A3%EF%BC%AC%EF%BC%A5%EF%BC%8F%E3%82%AA%E3%83%A9%E3%82%AF%E3%83%AB%EF%BC%B3%EF%BC%B1%EF%BC%AC%E3%83%AA%E3%83%95%E3%82%A1%E3%83%AC%E3%83%B3%E3%82%B9%EF%BC%88MAX%EF%BC%89&ln=en&ct=us&ce=1&osec=0&tm=&prt=&pvf=0&pvl=0&pvt=0&drt=&dvf=0&dvl=0&dvt=0&pname=06_max&chk=%E3%81%82" defer=""></script>
<noscript><A href="http://w1.ax.xrea.com/c.f?id=100263949" target="_blank"><IMG src="http://w1.ax.xrea.com/l.f?id=100263949&url=X" border="0"></A></noscript>


<center>

<table width="759">
  <tbody>
    <tr>
      <td>
<h1 style="font-size : 8pt;color : #494949;" align="right">ORACLE SQL リファレンス(逆引き)</h1>
</td>
      <td></td>
    </tr>
    <tr>
      <td width="623" valign="top" height="552">

		<div align="left">
      <table border="0" cellpadding="0" cellspacing="0">
        <colgroup><col span="1" width="10" />
        </colgroup><tbody>
          <tr>
            <td width="8"></td>
            <td align="center" width="597"><a href="http://oracle.se-free.com/"><img src="../img/banner.jpg" alt="ORACLE SQL リファレンス" width="391" height="90" border="0" /></a></td>
            <td align="center" width="597">

<!-- SiteSearch Google -->
<form method="get" action="http://www.google.co.jp/custom" target="google_window">
<table border="0" bgcolor="#ffffff">
<tbody><tr><td nowrap="nowrap" valign="top" align="left" height="32">

<br />
<input type="hidden" name="domains" value="oracle.se-free.com" />
<input type="text" name="q" size="32" maxlength="255" value="" />
</td></tr>
<tr>
<td nowrap="nowrap">
<table>
<tbody><tr>
<td>
<input type="radio" name="sitesearch" value="" />
<font size="-1" color="#000000">Web</font>
</td>
<td>
<input type="radio" name="sitesearch" value="oracle.se-free.com" checked="checked" />
<font size="-1" color="#000000">oracle.se-free.com</font>
</td>
</tr>
</tbody></table>
<input type="submit" name="sa" value="Google 検索" />
<input type="hidden" name="client" value="pub-3981107707611067" />
<input type="hidden" name="forid" value="1" />
<input type="hidden" name="channel" value="6278807835" />
<input type="hidden" name="ie" value="Shift_JIS" />
<input type="hidden" name="oe" value="Shift_JIS" />
<input type="hidden" name="cof" value="GALT:#008000;GL:1;DIV:#FFFFFF;VLC:663399;AH:center;BGC:FFFFFF;LBGC:FFFFFF;ALC:0000FF;LC:0000FF;T:000000;GFNT:0000FF;GIMP:0000FF;LH:50;LW:216;L:http://oracle.se-free.com/img/banner.jpg;S:http://;FORID:1;" />
<input type="hidden" name="hl" value="ja" />
</td></tr></tbody></table>
</form>
<!-- SiteSearch Google -->


</td>
          </tr>
          <tr>
            <td bgcolor="#000000" height="25" width="8"></td>
            <td bgcolor="#000000" height="25" style="font-size : 12pt;color : white" align="left" colspan="2" width="597"><b>最大値を取得する( MAX )</b></td>
          </tr>
          <tr>
            <td width="8" height="323"></td>
            <td align="left" colspan="2" valign="top" width="597" height="323">



スポンサード リンク<br />
<script type="text/javascript"><!--
google_ad_client = "ca-pub-3981107707611067";
/* ORACLE:メインコンテンツ上部 */
google_ad_slot = "8538034621";
google_ad_width = 468;
google_ad_height = 60;
//-->
</script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script>
<hr />
			
			
			
			
			<font color="black">数値項目の最大値の取得はMAX関数を使用します。</font><br />
            <br />
            <table width="587" height="66" border="1">
              <tbody>
                <tr>
                  <td width="176" height="60">MAX( 数値項目 )</td>
                  <td width="395">数値項目 の最大値を返します。</td>
                </tr>
              </tbody>
            </table>
            <br />
            サンプル表「emp」データ<br />
            <table>
              <tbody>
                <tr>
                  <td width="10" height="58"></td>
                  <td valign="top" width="553" bgcolor="#ddffff" height="58"><p>SQL> select * from emp;</p>
                    <p>EMP_ID DEPT_ID EMP_NAME  SALARY<br />
                      ------ ------ ---------- ----------<br />
                      E01    D01   なまえ1    150<br />
                      E02      D02   なまえ2    200<br />
                      E03      D03   なまえ3    300<br />
                      E04      D02   なまえ4             400<br />
                      E05      D03   なまえ5             500</p></td>
                </tr>
              </tbody>
            </table>
            <br />
            <br />
            <b>例1)</b> 列「salary」の最大値を取得します。<br />
            <table>
              <tbody>
                <tr>
                  <td width="10" height="58"></td>
                  <td valign="top" width="553" bgcolor="#ddffff" height="58"><p>SQL> select<br />
                      2  max( salary )<br />
                      3 from emp;</p>
                    <p>MAX(SALARY)<br />
                      -----------<br />
                      500<br />
                    </p></td>
                </tr>
              </tbody>
            </table>
            <br />
            <br />
            <b>例2)</b> 列「salary」の最大値を、列「dept_id」別に取得します。<br />
            <table>
              <tbody>
                <tr>
                  <td width="10" height="58"></td>
                  <td valign="top" width="553" bgcolor="#ddffff" height="58"><p>SQL> select<br />
                      2  max( salary )<br />
                      3 from emp<br />
                      4 group by dept_id;</p>
                    <p>MAX(SALARY)<br />
                      -----------<br />
                      150<br />
                      400<br />
                      500</p></td>
                </tr>
              </tbody>
            </table>
            <br />
            <br />
            <b>例3)</b> 列「salary」の最大値で、300以上の値を、列「dept_id」別に取得します。<br />
            <table>
              <tbody>
                <tr>
                  <td width="10" height="58"></td>
                  <td valign="top" width="553" bgcolor="#ddffff" height="58"><p>SQL> select<br />
                      2  max( salary )<br />
                      3 from emp<br />
                      4 group by dept_id<br />
                      5 having max( salary ) > 300;</p>
                    <p>MAX(SALARY)<br />
                      -----------<br />
                      400<br />
                      500</p></td>
                </tr>
              </tbody>
            </table>
            <br />


<hr />			
スポンサード リンク<br />
<script type="text/javascript"><!--
google_ad_client = "ca-pub-3981107707611067";
/* ORACLE:メインコンテンツ下部 */
google_ad_slot = "1757372216";
google_ad_width = 336;
google_ad_height = 280;
//-->
</script>
<script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
</script><ins id="aswift_0_expand" style="display: inline-table; border: none; height: 0px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent;" data-ad-slot="1757372216" tabindex="0" title="Advertisement" aria-label="Advertisement" data-ad-status="unfilled"><ins id="aswift_0_anchor" style="display: block; border: none; height: 0px; margin: 0px; padding: 0px; position: relative; visibility: visible; width: 336px; background-color: transparent; overflow: hidden; opacity: 0;"><iframe id="aswift_0" name="aswift_0" style="left: 0px; position: absolute; top: 0px; border: 0px; width: 336px; height: 0px;" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" width="336" height="0" frameborder="0" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3981107707611067&output=html&h=280&slotname=1757372216&adk=1477596412&adf=2480104190&pi=t.ma~as.1757372216&w=336&lmt=1281246011&url=http%3A%2F%2Foracle.se-free.com%2Fdml%2F06_max.html&ea=0&flash=0&wgl=1&dt=1623365612448&bpp=40&bdt=127755&idt=684&shv=r20210607&cbv=%2Fr20190131&ptt=5&saldr=sa&abxe=1&correlator=3217099117014&frm=20&pv=2&ga_vid=1118410791.1623365613&ga_sid=1623365613&ga_hid=1061205207&ga_fc=0&u_tz=540&u_his=2&u_java=0&u_h=600&u_w=800&u_ah=600&u_aw=800&u_cd=24&u_nplug=0&u_nmime=0&adx=11&ady=1313&biw=785&bih=585&scr_x=0&scr_y=0&eid=42530672%2C31060615&oid=3&pvsid=2129442338447655&pem=518&eae=4&fc=640&brdim=0%2C0%2C0%2C0%2C800%2C0%2C800%2C600%2C800%2C600&vis=1&rsz=d%7Cd%7CeEbr%7C&abl=NS&pfx=0&fu=1024&bc=23&ifi=1&uci=a!1&btvi=1&fsb=1&dtd=739" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" data-google-container-id="a!1" data-load-complete="true" data-google-query-id="CLGs0JWUjvECFUXJvQodwPUDig"></iframe></ins></ins>
<hr />
			
			
			
            <br />
            </td>
          </tr>
          <tr>
            <td height="44"></td>
            <td colspan="2" valign="top" height="44">
            <table border="0" width="583" cellspacing="4">
              <tbody><tr>
                <td>→<a href="06_count.html">レコード件数を取得する( COUNT )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_max.html">最大値を取得する( MAX )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_avg.html">平均値を取得する( AVG )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_min.html">最小値を取得する( MIN )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_sum.html">グループ単位に集計する( SUM、GROUP BY )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_having.html">グループ単位に集計結果の値から指定条件でレコードを抽出する( HAVING )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_rank_within.html">ランキング(仮説ランク)を取得する( RANK、DENSE_RANK )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_pcnt_rank_within.html">パーセントランク(仮説ランク)を取得する( PERCENT_RANK )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_keep_first.html">ソートしたレコードの先頭行に集計関数を使用する( KEEP、FIRST )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_keep_last.html">ソートしたレコードの最終行に集計関数を使用する( KEEP、LAST )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_rollup.html">小計を計算する( ROLLUP )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_cube.html">クロス集計する( CUBE )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_grouping.html">小計行とグループ化された集計行を区別する( GROUPING、GROUPING_ID )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_stddev.html">標準偏差を取得する( STDDEV )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_stddev_samp.html">累積標準偏差を取得する( STDDEV_SAMP )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_stddev_pop.html">母集団標準偏差を取得する( STDDEV_POP )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_variance.html">分散を取得する( VARIANCE )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_var_samp.html">累積分散を取得する( VAR_SAMP )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_stddev_pop.html">母集団分散を取得する( VAR_POP )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_median.html">中央値を取得する( MEDIAN )</a></td>
              </tr>
              <tr>
                <td>→<a href="06_corr.html">相関係数を取得する( CORR )</a></td>
              </tr>
              </tbody><tbody>
                <tr>
                  <td><br />
                  →<a href="dml.html">SQL(DML) へ</a></td>
                </tr>
                <tr>
                  <td>→<a href="http://oracle.se-free.com/">忘れっぽいエンジニアのオラクルSQLリファレンス TOPへ</a></td>
                </tr>
              </tbody>
            </table>
            </td>
          </tr>
        </tbody>
      </table>
      </div>
      </td>
      <td bgcolor="#ffcc00" valign="top" align="center" width="63" height="552">
      <div align="left">
      <table cellpadding="20">
        
          
          <tbody>
          <tr>
            <td valign="middle" height="346">

	<table border="0" cellpadding="0" cellspacing="0" width="95" bgcolor="black" height="320">
          <tbody>
                <tr>
            <td valign="middle">
            <table border="0" cellpadding="0" cellspacing="1" width="95" height="320">
              
                <tbody>
                    <tr>
                  <td align="center" bgcolor="white" style="line-height : 100%;"><a href="http://oracle.se-free.com/">TOP</a><br />
|<br />
<a href="../dml/dml.html">SQL(DML)<br />
</a>|<br />
<a href="../dml/dml_02.html">SQL(DML2)<br />
</a>|<br />
<a href="../ddl/ddl.html">SQL(DDL)<br />
</a>|<br />
<a href="../tuning/tuning.html">チューニング<br />
</a>|<br />
<a href="../utl/utl.html">ユーティリティ<br />
</a>|<br />
<a href="../plsql/plsql.html">PL/SQL<br />
</a>|<br />
<a href="../jdbc/jdbc.html">JDBC<br />
</a>|<br />
<a href="../dic/dic.html">ディクショナリ<br />
</a>|<br />
<a href="../index/index.html">INDEX<br />
</a></td>
                </tr>
              
            </tbody>
                  </table>
            </td>
          </tr>
            </tbody>
            </table>
            </td>
          </tr>
          <tr>
            <td height="115"></td>
          </tr>
        </tbody>
      </table>
      </div>
      </td>
    </tr>
  </tbody>
</table>


</center>


<iframe id="google_osd_static_frame_5031045082491" name="google_osd_static_frame" style="display: none; width: 0px; height: 0px;"></iframe><ins class="adsbygoogle adsbygoogle-noablate" data-adsbygoogle-status="done" style="display: none !important;"><ins id="aswift_1_expand" style="display:inline-table;border:none;height:0px;margin:0;padding:0;position:relative;visibility:visible;width:0px;background-color:transparent;" tabindex="0" title="Advertisement" aria-label="Advertisement"><ins id="aswift_1_anchor" style="display:block;border:none;height:0px;margin:0;padding:0;position:relative;visibility:visible;width:0px;background-color:transparent;"><iframe id="aswift_1" name="aswift_1" style="left:0;position:absolute;top:0;border:0;width:undefinedpx;height:undefinedpx;" sandbox="allow-forms allow-popups allow-popups-to-escape-sandbox allow-same-origin allow-scripts allow-top-navigation-by-user-activation" frameborder="0" src="https://googleads.g.doubleclick.net/pagead/ads?client=ca-pub-3981107707611067&output=html&adk=1812271804&adf=3025194257&lmt=1281246011&plat=9%3A32768%2C16%3A8388608%2C17%3A32%2C24%3A32%2C25%3A32%2C30%3A1048576%2C32%3A32&format=0x0&url=http%3A%2F%2Foracle.se-free.com%2Fdml%2F06_max.html&ea=0&flash=0&pra=7&wgl=1&dt=1623365740506&bpp=6&bdt=255813&idt=7&shv=r20210607&cbv=%2Fr20190131&ptt=9&saldr=aa&abxe=1&prev_slotnames=1757372216&nras=1&correlator=3217099117014&frm=20&pv=1&ga_vid=1118410791.1623365613&ga_sid=1623365613&ga_hid=1061205207&ga_fc=0&u_tz=540&u_his=2&u_java=0&u_h=600&u_w=800&u_ah=600&u_aw=800&u_cd=24&u_nplug=0&u_nmime=0&adx=-12245933&ady=-12245933&biw=808&bih=1009&scr_x=0&scr_y=0&eid=42530672%2C31060615&oid=3&pvsid=2129442338447655&pem=518&eae=6&fc=1920&brdim=0%2C0%2C0%2C0%2C800%2C0%2C823%2C1024%2C823%2C1024&vis=1&rsz=%7C%7Cs%7C&abl=NS&fu=33792&bc=23&ifi=2&uci=a!2&fsb=1&dtd=22" marginwidth="0" marginheight="0" vspace="0" hspace="0" allowtransparency="true" scrolling="no" allowfullscreen="true" data-google-container-id="a!2" data-load-complete="true"></iframe></ins></ins></ins></body><iframe id="google_esf" name="google_esf" src="https://googleads.g.doubleclick.net/pagead/html/r20210607/r20190131/zrt_lookup.html" style="display: none;"></iframe></html>