MySQL Forums
Forum List  »  Newbie

Re: Select unique data
Posted by: Phillip Ward
Date: February 07, 2023 08:12AM

Each src and the earliest call date for each?

select 
  src
, min( calldate ) earliest 
from cdr 
where ... 
group by src 
order by src

Regards, Phill W.

Options: ReplyQuote


Subject
Written By
Posted
February 06, 2023 02:21AM
February 06, 2023 08:56AM
February 07, 2023 04:26AM
Re: Select unique data
February 07, 2023 08:12AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.