下記のテーブルから各IDごとの最新2件のデータを一回のSQLで抽出したいのですが UNIONを使えばできました。 UNIONは実行結果をひとつにまとめてるだけなので結局2回SQLを実行していますよね？ UNIONを使わずに1回の実行で抽出は可能でしょうか。 またもっとスマートな抽出方法がありましたら教えてください。 元テーブル：TABLE_A ID|Address | create_date 1 | 東京 | 2010-03-01 2 | 福岡 | 2010-03-02 1 | 東京 | 2010-03-03 1 | 東京 | 2010-03-04 2 | 福岡 | 2010-02-05 1 | 東京 | 2010-03-06 1 | 東京 | 2010-03-07 2 | 福岡 | 2010-03-08 1 | 東京 | 2010-03-09 1 | 東京 | 2010-03-10 2
タグ
- すべて
- book, monitoring (1)
- 1password (2)
- activemq (1)
- ads (1)
- adtech (4)
- algorithms (1)
- amazon tool (1)
- android (2)
- android, nexus (2)
- angular.js (1)
- angularjs (1)
- angularjs, bootstrap (1)
- ansible (5)
- apache (3)
- api, web (1)
- apple gpl (1)
- audio (1)
- authentication, web (1)
- autossh, ssh (1)
- aws (17)
- aws dynamodb (1)
- aws server (1)
- aws, aurora (1)
- aws, dynamo (1)
- aws, ec2 (1)
- aws, gcp, cloud (2)
- aws, linux, centos (1)
- aws, monitoring (1)
- aws, server (4)
- aws, ses (1)
- aws, ssl (1)
- backup, server (1)
- bash, linux, security (1)
- benchmark, server (1)
- bittorent (1)
- bluetooth (1)
- book (2)
- book unix (1)
- bookmark (1)
- bootstrap (6)
- bootstrap, angular.js (1)
- bootstrap, templates (1)
- bootstrap, theme (1)
- bootstrap, themes (2)
- bootstrap, web (1)
- boxen (1)
- browser (1)
- browser, selenium (1)
- capistrano (1)
- capture, web (1)
- cassandra rpm (1)
- cassandra, server (1)
- centos (7)
- centos server (1)
- centos, tomcat, server (1)
- chair (2)
- chat (1)
- chef (8)
- chef, ci (1)
- chrome (2)
- chromedriver, web (1)
- chromeos (1)
- ci, development (1)
- circleci, docker (1)
- cloud, google (1)
- cloud, server, ubuntu (1)
- cloud, syslog (1)
- cloudformation (1)
- cobbler, server (2)
- coding, development (1)
- collectd, monitoring (1)
- conference (1)
- conference, conf, mysql (1)
- conference, mysql (2)
- conference, qcon (1)
- cookbooks, chef (1)
- coreos (2)
- cpu, server (2)
- dash, fuelphp (1)
- database (2)
- database, metrics (1)
- database, php, web, development (1)
- datacenter, server (1)
- datadog (4)
- datadog, monitoring, redis (1)
- db, java (1)
- dbtech (1)
- deploy, ruby (1)
- desigin, css (1)
- design (2)
- design, mobile, web (1)
- design, web (1)
- development (2)
- development, web (2)
- devops (2)
- devops, automation (1)
- devopsdays (1)
- devsami (1)
- dns (3)
- docker (9)
- docker, (1)
- docker, google, container (1)
- docker, rhel (1)
- docker, wercker (1)
- dotfiles, bash (1)
- dotfiles, github (1)
- drinking (1)
- dsync, rsync (1)
- ebook (1)
- ec2, server (1)
- ecs (2)
- editor, emacs, color (1)
- elasticsearch (3)
- elastricsearch, kibana (1)
- emacs (26)
- emacs, blog (1)
- emacs, book (1)
- emacs, osx (1)
- embulk (2)
- embulk, oss (1)
- engineer, twitter (1)
- english (2)
- facebook (2)
- facebook, server (1)
- fedora, linux (1)
- firefox (7)
- firefox stylish (1)
- firefox, autopagerize (1)
- firefox, google, chrome (1)
- firefox, userstyle (2)
- firefox, youtube (1)
- fluentd (7)
- fluentd, datadog (1)
- fluentd, s3 (1)
- flume (1)
- font, google (1)
- fonts (1)
- fonts, programming (1)
- freebsd (1)
- freebsd, server (1)
- gadgets, macbook (1)
- ganglia (1)
- ganglia graphite server (1)
- ganglia, mysql (1)
- geoip (2)
- ghe, git, server (1)
- git (5)
- git, server (1)
- git, svn (2)
- git, web (1)
- git, zsh (1)
- github (9)
- github ruby unicorn (1)
- github, dev (1)
- github, devops (1)
- github, editor (1)
- github, markdown (1)
- github, screensaver (1)
- github, server (1)
- github, ssh (1)
- global (1)
- gmail (1)
- gnu, osx (1)
- google (2)
- google, (1)
- google, auth, go (1)
- google, mobile (1)
- graphite, golang (1)
- graphite, monitoring (2)
- graphite, monitoring, visualizat (1)
- graphite, server (1)
- grub, linux (1)
- gzip (1)
- hadoop (8)
- hadoop, monitoring (1)
- hadoop, prestro (1)
- hadoop, twitter (1)
- hashicorp (2)
- hatena (2)
- hatena, server (1)
- hbase (2)
- help, javadoc, java (1)
- hibari, kvs (1)
- homebrew (1)
- hosting, cloud, server (1)
- hp server debian (1)
- html, javascript (1)
- html5 (2)
- html5, angularjs (1)
- http (2)
- http, benchmark (1)
- http, server (1)
- http2, h2o, webserver (1)
- icon, web (1)
- idc, idea, game (1)
- ie (1)
- ie, microsoft (1)
- image (1)
- imagemagick (1)
- influxdb, monitoring (1)
- infra (4)
- infra, presentation (1)
- iodrive, server (1)
- ios (5)
- ios, httpd, network (1)
- ios, news (1)
- ios, twitter (1)
- ipad (1)
- iphone (4)
- ipv6, server, network (1)
- java (8)
- java, jvm (2)
- javascript (5)
- javascript, jquery (1)
- javascript, web (2)
- jemalloc, algorithms (1)
- jemalloc, ruby (1)
- jenkins (3)
- jmeter, server (1)
- jobqueue, ruby (2)
- json, aws (1)
- json, server (1)
- jvm, jvmcasual (1)
- keepalived (1)
- kernel, linux (1)
- keyboard (1)
- keynote, presentation (1)
- keyswitch (2)
- kickstart (1)
- kindle (1)
- kinesis (1)
- kubernetes (2)
- kumofs, server (1)
- kvm (4)
- kvm, centos (2)
- l (1)
- leap, interface (1)
- leapseconds (2)
- leapseconds, hbase (1)
- leapseconds, rhel (1)
- libressl, openssl (1)
- life (8)
- life web (1)
- life, company (1)
- life, creditcard (1)
- life, engilish (1)
- life, engineer (1)
- linkedlin, engineer (1)
- linux (21)
- linux server (5)
- linux ssh server (1)
- linux upstart (1)
- linux, aws, ec2 (1)
- linux, bind (1)
- linux, centos (1)
- linux, expect (1)
- linux, less (1)
- linux, rhel, kvm, server (1)
- linux, rpm, server (1)
- linux, server, graphite (1)
- linux, ubuntu (1)
- logging, monitoring, exception (1)
- lvs, server (2)
- lvs, sever (1)
- mac (5)
- mac, ipad (1)
- macbook (3)
- macbookair (2)
- mackerel (1)
- macmini (1)
- mail (1)
- mail, server (1)
- memcached (1)
- metrics, js (1)
- metrics, server (1)
- micrsoft, editor (1)
- mobile (1)
- mobile, design, web (2)
- mongo (1)
- mongodb (1)
- monitoring (1)
- monitoring, server (5)
- monitoring, web (1)
- mosh, server (1)
- mruby (1)
- mysql (34)
- mysql, datadog, rds (1)
- mysql, google (1)
- mysql, leapseconds (1)
- mysql, mha (1)
- mysql, osx (1)
- mysql, twitter (1)
- mysql, youtube (1)
- nagios (2)
- nagios, sensu (1)
- nginx (1)
- nginx, digitalocean (1)
- nginx, server (4)
- nginx, webserver (1)
- nodejs (1)
- nxclient linux osx (1)
- onhub, ifttt (1)
- openssl (1)
- openssl, openvpn (1)
- openssl, security (1)
- openstack, storage (1)
- openvpn (1)
- openvpn, server, ubuntu (1)
- oss, netflix (1)
- osx (45)
- osx ruby rails (1)
- osx software (1)
- osx twitter (1)
- osx vnc (1)
- osx, apache (1)
- osx, boxen (1)
- osx, development (1)
- osx, dnsmasq (1)
- osx, dotfiles (1)
- osx, editor, markdown, yaml (1)
- osx, ios (1)
- osx, iterm2 (3)
- osx, jssh (1)
- osx, postgresql (1)
- osx, software (1)
- osx, terminal (1)
- osx, ubuntu (1)
- osx, yosemite (1)
- osx, zsh (1)
- passenger (1)
- passenger, ruby (1)
- performance, web (1)
- php (5)
- php, benchmark (1)
- php, hhvm (2)
- php, imagemagick (1)
- php, nginx (1)
- postgresql (3)
- pow, osx (1)
- powerdns (1)
- preseed, database, debian (1)
- presentation (1)
- pressed, ubuntu (1)
- procmail (4)
- programming (1)
- puppet (1)
- python (2)
- python, performance (1)
- quicktime (1)
- rails (6)
- rails, server (1)
- rais, heroku, ruby (1)
- rbenv (1)
- reactjs (1)
- redis (3)
- redis, memcached, twitter (1)
- reinvent (1)
- retina (1)
- rhel (1)
- rhel, server (1)
- rhel, server, linux (1)
- riack, server (2)
- rpm (2)
- rpsec (2)
- rspec (2)
- rtx, network (1)
- ruby (18)
- ruby server (1)
- ruby, english (1)
- ruby, rails (2)
- ruby, rails, help (1)
- ruby, server (1)
- ruby, sinatra (1)
- ruby, ubuntu (1)
- ruby, webserver (1)
- salesforce, css (1)
- scala (4)
- scalability, web (1)
- screen (2)
- security (3)
- security, web, development (1)
- selenium, web (2)
- server (25)
- server alerts (1)
- server alerts, server, linux (1)
- server linux (1)
- server, automation (1)
- server, chef (2)
- server, cobbler (2)
- server, elastricsearch (2)
- server, facebook (1)
- server, github (1)
- server, graphite (3)
- server, grub (2)
- server, hadoop (1)
- server, haskel (1)
- server, hp (2)
- server, java (2)
- server, jmeter (1)
- server, kvm (1)
- server, kvs (1)
- server, linux (10)
- server, linux, debian (1)
- server, linux, ubuntu (1)
- server, lvs (1)
- server, monitoring (2)
- server, monitoring, lvs (1)
- server, monitoring, scalability (1)
- server, mysql (3)
- server, network, book (1)
- server, package (1)
- server, pdns (1)
- server, php (2)
- server, pptp (1)
- server, puppet (1)
- server, python (1)
- server, rhel, security, bash (1)
- server, riak (1)
- server, rsync (2)
- server, rsyslog (1)
- server, servlet (1)
- server, shell (1)
- server, ssh (9)
- server, ssh, linux (1)
- server, ssl (2)
- server, statsd (1)
- server, swift (2)
- server, twitter (1)
- server, ubuntu (10)
- server, unicorn (1)
- server, vagrant (1)
- server, varnish (1)
- server, webhosting, datacenter (1)
- server, xen (1)
- sever, linux (1)
- sever, ssh (1)
- shell (1)
- sicp (1)
- sicp, computer (1)
- slack, api (1)
- spdy, rails (1)
- ssd (1)
- ssd, server (1)
- ssh (8)
- ssh server (1)
- ssh, osx (2)
- ssh, security, server (1)
- ssh, server (3)
- ssl (1)
- ssl, server (1)
- storage, facebook (1)
- supervisor (2)
- supervisor server (1)
- svn (1)
- swift (1)
- switch, cisco (1)
- tech, google (1)
- terraform (3)
- tmux (5)
- tmux, zsh (1)
- tomcat, java (3)
- tool, development (1)
- twitter ios (1)
- twitter, ads, api (1)
- twitter, development (1)
- twitter, ios (1)
- twitter, java (1)
- ubuntu (6)
- ubuntu server (1)
- ubuntu, devops (1)
- ubuntu, kvm (1)
- ubuntu, mysql (1)
- ubuntu, server (2)
- ui, web (1)
- unicorn, nginx, server, ruby (1)
- unicorn, ruby (2)
- unoh (2)
- vagrant (6)
- velocity, netflix, linux (1)
- velocityconf (1)
- vm (1)
- vm server (1)
- vmware (1)
- vmware, osx (2)
- vmware, server (2)
- vnc, osx (1)
- vpn (1)
- vpn, ubuntu (1)
- web (5)
- web image (1)
- web server (1)
- web tools (1)
- web, api (1)
- web, automation, programming (1)
- web, bigquery (1)
- web, browser (2)
- web, css (1)
- web, design (2)
- web, history (1)
- web, icon (5)
- web, infra (2)
- web, javascript (1)
- web, monitoring, prometheus (1)
- web, oss (1)
- web, security, authentication (1)
- web, smartphone (1)
- web, tech (1)
- wget (1)
- windows (1)
- windows, ci (1)
- windows, ssh (1)
- zsh (23)
- osx (45)
- mysql (34)
- emacs (26)
- server (25)
- zsh (23)
- linux (21)
- ruby (18)
- aws (17)
- server, linux (10)
- server, ubuntu (10)
2014年12月15日のブックマーク (1件)
-
n0ts 2014/12/15
各IDごとの上位のデータを取得する方法- mysql
リンク -
- 2014年12月16日
- 2014年12月15日
- 2014年12月11日
公式Twitter
- @HatenaBookmark
リリース、障害情報などのサービスのお知らせ
- @hatebu
最新の人気エントリーの配信
処理を実行中です
キーボードショートカット一覧
j次のブックマーク
k前のブックマーク
lあとで読む
eコメント一覧を開く
oページを開く
設定を変更しましたx