Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.
Visit Stack Exchange
Stack Internal
Knowledge at work
Bring the best of human thought and AI automation together at your work.
Explore Stack InternalAnMy table structure and some sample data (test table), as well as my desired output (results) are available example + expected resultshere of my request.
When I do
SELECT distinct colony, min(date_check), max(date_check) from test where protection ='Y' group by colony I only detect 1 event by colony.
Should I use a function or is there another way ?
ps : if you think of a better title to help users, don't hestitate, I struggled.
An example + expected results of my request.
When I do
SELECT distinct colony, min(date_check), max(date_check) from test where protection ='Y' group by colony I only detect 1 event by colony.
Should I use a function or is there another way ?
ps : if you think of a better title to help users, don't hestitate, I struggled.
My table structure and some sample data (test table), as well as my desired output (results) are available here.
When I do
SELECT distinct colony, min(date_check), max(date_check) from test where protection ='Y' group by colony I only detect 1 event by colony.
Should I use a function or is there another way ?
ps : if you think of a better title to help users, don't hestitate, I struggled.
An example + expected results of my request.
When I do
SELECT distinct colony, min(date_check), max(date_check) from test where protection ='Y' group by colony I only detect 1 event by colony.
Should I use a function or is there another way ?
ps : if you think of a better title to help users, don't hestitate, I struggled.