{"action":"closed","issue":{"url":"https://api.github.com/repos/jinzhu/gorm/issues/638","labels_url":"https://api.github.com/repos/jinzhu/gorm/issues/638/labels{/name}","comments_url":"https://api.github.com/repos/jinzhu/gorm/issues/638/comments","events_url":"https://api.github.com/repos/jinzhu/gorm/issues/638/events","html_url":"https://github.com/jinzhu/gorm/issues/638","id":103205784,"number":638,"title":"When I select MAX() and MIN() for same column, How can I Scan it ? ","user":{"login":"sotayamashita","id":1587053,"avatar_url":"https://avatars.githubusercontent.com/u/1587053?v=3","gravatar_id":"","url":"https://api.github.com/users/sotayamashita","html_url":"https://github.com/sotayamashita","followers_url":"https://api.github.com/users/sotayamashita/followers","following_url":"https://api.github.com/users/sotayamashita/following{/other_user}","gists_url":"https://api.github.com/users/sotayamashita/gists{/gist_id}","starred_url":"https://api.github.com/users/sotayamashita/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/sotayamashita/subscriptions","organizations_url":"https://api.github.com/users/sotayamashita/orgs","repos_url":"https://api.github.com/users/sotayamashita/repos","events_url":"https://api.github.com/users/sotayamashita/events{/privacy}","received_events_url":"https://api.github.com/users/sotayamashita/received_events","type":"User","site_admin":false},"labels":[],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2015-08-26T08:16:51Z","updated_at":"2015-08-26T09:08:09Z","closed_at":"2015-08-26T09:08:09Z","body":"For example, Here is a table named **A** and I run query `SELECT MIN(size), MAX(size) FROM A; `\r\n\r\n```\r\nmysql > show columns from A;\r\n+----+------+\r\n| id | size |\r\n+----+------+\r\n|  1 |    4 |\r\n|  2 |    0 |\r\n+----+------+\r\n\r\nmysql > select max(size), min(size) from A;\r\n+-----------+-----------+\r\n| max(size) | min(size) |\r\n+-----------+-----------+\r\n|         4 |         0 |\r\n+-----------+-----------+\r\n```\r\n\r\n"}}