如何在SQL中进行GROUP和选择最低值 [英] How to GROUP and choose lowest value in SQL

问题描述

我有这些字段组成的表：

  id | date_from | date_to |价格
 -------------------------------------------- 
 CK1 22-12-2012 29-12-2012 800 
 CK1 22-12-2012 29-12-2012 1200 
 CK2 22-12-2012 29-12-2012 1400 
 CK2 22-12-2012 29-12-2012 1800 
 CK2 22-12-2012 29-12-2012 2200 
  

如何创建SQL select通过ID，DATE_FROM，DATE_TO分组结果并从价格中选择最低值。

所以结果将是

  CK1 22-12-2012 29-12-2012 800 
 CK2 22-12-2012 29-12-2012 1400 
  

解决方案

  select id，date_from，date_to，min（price）
 from table 
 group by id，date_from，date_to 
  

I have table consisting of these fields:

 id  |   date_from  | date_to      |   price
 --------------------------------------------
 CK1     22-12-2012   29-12-2012       800
 CK1     22-12-2012   29-12-2012       1200
 CK2     22-12-2012   29-12-2012       1400
 CK2     22-12-2012   29-12-2012       1800
 CK2     22-12-2012   29-12-2012       2200

How do I create SQL select that groups results by ID, DATE_FROM, DATE_TO and picks lowest value from price.

So result would be

 CK1     22-12-2012   29-12-2012       800
 CK2     22-12-2012   29-12-2012       1400

解决方案

select id, date_from, date_to, min(price)
from table
group by id, date_from, date_to

这篇关于如何在SQL中进行GROUP和选择最低值的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！