Help in Query Latest -- Urgent

From: Shafeek Khalidh <itsprobablyme_at_msn.com>
Date: Wed, 30 Jul 2003 23:04:31 -0700
Message-ID: <bgabhf$meiso$1@ID-137434.news.uni-berlin.de>

Hi all,

Here is a table structure,
Cource_table

---

ID
End_Cource_date
Teacher_id

Test Data...........
ID --End_Cource_date-----Teacher_id

---

1 ---1/1/2003------------T100
2----2/2/2003------------T100
3----1/2/2003------------T100
4----Null-----------------T100
5----2/1/2003------------T101
6----3/1/2003------------T101
7----4/1/2003------------T101
8----2/1/2003------------T101

I want to get the latest two ids corresponding to each teacher.If the date is null, Thats the latest date. (mm/dd/yyyy format)

One more thing, I need the results as the following format, Teacher_id------End_Cource_date-----Second_End_Cource_date

---

T100------------Null-------------------2/2/2003

T101------------4/1/2003--------------3/1/2003

Please help
Thanks
Shafeek Khalidh Received on Thu Jul 31 2003 - 01:04:31 CDT