SQL Query

From: Ha Kong Kuen <kkha_at_hkuxa.hku.hk>
Date: Wed, 15 Mar 1995 07:16:36 GMT
Message-ID: <D5H07p.2vq_at_hkuxb.hku.hk>


        I have simple question:

                I have a table with several columns, e.g.

			Staff No,
			Department No,
			Post Held    
			Start Date


		For each staff, it is possible to have the same
	department and post with with different start dates. 
	How can I ,say retrieve , those with same staff_no, department
	No and Post Held and yet with the earliest start date or
	the greatest start date?

	Thanks for any hints.

					Anthony HA
Received on Wed Mar 15 1995 - 08:16:36 CET

Original text of this message