pedro at plex.nl
pedro at plex.nl
Mon Dec 6 13:36:20 CST 2010
Dear list, normally i use Group by and min max, to create a list of min or max (or first-last) dates per Patient. But when there is a third column which has different values, I'll make a key from date and patient-number and then ad the extra value. How can i do this in one simple query? I have 001 1-1-10 5 001 2-2-10 7 002 3-2-10 8 002 3-2-10 6 i need 001 1-1-10 5 002 3-2-10 6 Thanks Pedro