SQL Server : getting multiple min/max values from one query

Question

I have data similar to the following in SQL Server. I would like to query the single table for the category, min value from StartDate and max value from EndDate. Hopefully the following mock up of the data will help explain - thanks

DATA:

  Category  StartDate   EndDate
  -------------------------------
       A    1/1/2018    1/11/2018
       A    1/3/2018    1/13/2018
       B    1/1/2018    1/11/2018
       B    1/9/2018    1/19/2018
       A    1/5/2018    1/15/2018
       C    1/4/2018    1/14/2018
       A    1/1/2018    1/11/2018
       C    1/7/2018    1/17/2018

Desired result of query:

  Category  StartDate   EndDate
  --------------------------------
       A    1/1/2018    1/15/2018
       B    1/1/2018    1/19/2018
       C    1/4/2018    1/17/2018

Yogesh Sharma · Accepted Answer · 2018-05-10 17:50:58Z

4

What's wrong with GROUP BY and MIN() & MAX() ?

select Category, min(startdate) startdate, max(enddate) enddate
from table t
group by Category;

answered May 10, 2018 at 17:50

Yogesh Sharma

50.2k5 gold badges31 silver badges53 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

ScaisEdge · Accepted Answer · 2018-05-10 17:51:11Z

3

Use group by

select category, min(startDate), max(endDate)
from my_table  
group by category

answered May 10, 2018 at 17:51

ScaisEdge

134k10 gold badges98 silver badges111 bronze badges

1 Comment

mjordan Over a year ago

Thanks! I thought it would be more involved.

Collectives™ on Stack Overflow

SQL Server : getting multiple min/max values from one query

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related