I require assistance with the following table:
sample cycle idtype sample_date res1 res2
------- --- ------ ----------- --- ----
6861 1 M 05/17/1999 D <NULL>
6080 1 M 11/17/2000 A P
6080 1 M 05/19/1999 A J
6140 1 C 01/06/2000 D P
6140 1 M 06/23/1999 D J
6806 1 C 08/08/2001 A P
I need to select the first occurence of each sample from the above table. My results should be:
sample cycle idtype sample_date res1 res2
------- --- ------ ----------- --- ----
6861 1 M 05/17/1999 D <NULL>
6080 1 M 11/17/2000 A P
6140 1 C 01/06/2000 D P
6806 1 C 08/08/2001 A P
ALL HELP is greatly appreciated.
Deborah
sample cycle idtype sample_date res1 res2
------- --- ------ ----------- --- ----
6861 1 M 05/17/1999 D <NULL>
6080 1 M 11/17/2000 A P
6080 1 M 05/19/1999 A J
6140 1 C 01/06/2000 D P
6140 1 M 06/23/1999 D J
6806 1 C 08/08/2001 A P
I need to select the first occurence of each sample from the above table. My results should be:
sample cycle idtype sample_date res1 res2
------- --- ------ ----------- --- ----
6861 1 M 05/17/1999 D <NULL>
6080 1 M 11/17/2000 A P
6140 1 C 01/06/2000 D P
6806 1 C 08/08/2001 A P
ALL HELP is greatly appreciated.
Deborah