Given the following table:
Date Trd (INT(10)) Code (VARCHAR(10)) T-Date 1-Jan-14 1 B 1-Nov-13 1-Jan-14 2 B 3-Oct-13 1-Jan-14 2 B 3-Oct-13 2-Jan-14 1 A 1-Nov-13 2-Jan-14 2 A 3-Oct-13 2-Jan-14 2 A 3-Oct-13 2-Jan-14 3 A 2-Jan-14 3-Jan-14 2 A 3-Oct-13 3-Jan-14 2 A 3-Oct-13 3-Jan-14 3 A 2-Jan-14 3-Jan-14 4 C 3-Jan-14
How do I
SELECT, to get the following result:
Date Trd (INT(10)) First showed up as Code In Date T-Date 3-Jan-14 2 B 1-Jan-14 3-Oct-13 3-Jan-14 3 A 2-Jan-14 2-Jan-14 3-Jan-14 4 C 3-Jan-14 3-Jan-14
So for a given
Date (in this case Jan-3rd),
GROUP BY Trd and find out with which
Code it first showed up, and provide the
Date that happened.
I have no idea where to start.