DROP DATABASE

Technical Article

RE: Selection of Max value from 3 different columns?

  • Reply

Yes, your SELECT CASE WHEN ScheduleTime1 > ScheduleTime2 THEN CASE WHEN ScheduleTime1 > ScheduleTime3 THEN ScheduleTime1 ELSE ScheduleTime3 END ELSE CASE WHEN ScheduleTime2 > ScheduleTime3 THEN ScheduleTime2 ELSE ScheduleTime3 END END FROM ...and the one I postedSELECT CASE  WHEN MAX(col1) > MAX(col2) THEN   CASE    WHEN MAX(col1) > MAX(col3) THEN MAX(col1)    ELSE MAX(col3) […]

You rated this post out of 5. Change rating

2005-04-14

Blogs

SQL Saturday Boston 2024 Slides

By

Thanks to everyone that came to my talks. Slides are below. Best Practices for...

Small Data SF 2024

By

I can’t remember how I heard about Small Data SF 2024, but it caught...

A New Word: Moledro

By

moledro – n. a feeling of resonant connection with an author or artist you’ll...

Read the latest Blogs

Forums

7 sept, scheduled book

By philip.scott

Comments posted to this topic are about the item 7 sept, scheduled book

7 sept, schedlued article

By philip.scott

Comments posted to this topic are about the item 7 sept, schedlued article

6 sept, published book

By philip.scott

Comments posted to this topic are about the item 6 sept, published book

Visit the forum

Question of the Day

Azure Data Lake Storage Gen 2

Azure Data Lake Storage Gen 2 is built on ...?

See possible answers