SQL required for selecting records based on priority
I want a query that will select the records from data below:

condition : select only those record that highest priority in the group (COB,CUR1,CUR2).
Legend: 1 is Highest Priority and 3 is lowest Priority. 

    KEY		COB			CUR1 	CUR2	RATE		PRIORITY
    ------	--------	-----	----	--------	--------
    46051	3/9/2012	AUD		USD		1.0573		1
    44392	3/9/2012	AUD		USD		1.06195		2
    43122	3/9/2012	AUD		USD		1.06585		3
    44394	3/9/2012	BMD		USD		1.0000		2   	
    44395	3/9/2012	BSD		USD		1.0000		2   	
    46052	3/9/2012	BWP		USD		0.13875		1
    44402	3/9/2012	BWP		USD		0.13925		2
    46053	3/9/2012	DKK		RON		0.5859		1
    44406	3/9/2012	EUR		CSD		110.62		2
    46090	3/9/2012	EUR		USD		1.3109		1
    44434	3/9/2012	EUR		USD		1.31185		2
    43154	3/9/2012	EUR		USD		1.32556		3
    44436	3/9/2012	FJD		USD		0.564		2
    43156	3/9/2012	FJD		USD		0.5686		3
    46092	3/9/2012	FKP		USD		1.51195		1
    44437	3/9/2012	GBN		USD		1.6339		2
    43185	3/9/2012	GBP		USD		1.57985		3


output should be :

    KEY		COB			CUR1 	CUR2	RATE		PRIORITY
    ------	--------	-----	----	--------	--------
    46051	3/9/2012	AUD		USD		1.0573		1
    44394	3/9/2012	BMD		USD		1.0000		2   	
    44395	3/9/2012	BSD		USD		1.000		2   	
    44402	3/9/2012	BWP		USD		0.13925		2
    46053	3/9/2012	DKK		RON		0.5859		1
    44406	3/9/2012	EUR		CSD		110.62		2
    46090	3/9/2012	EUR		USD		1.3109		1
    44436	3/9/2012	FJD		USD		0.564		2
    46092	3/9/2012	FKP		USD		1.51195		1
    44437	3/9/2012	GBN		USD		1.6339		2
    43185	3/9/2012	GBP		USD		1.57985		3


Please provide your inputs ?

SQL required for selecting records based on priority
===

I want a query that will select the records from data below:

condition : select only those record that highest priority in the group (COB,CUR1,CUR2).
Legend: 1 is Highest Priority and 3 is lowest Priority. 

    KEY		COB			CUR1 	CUR2	RATE		PRIORITY
    ------	--------	-----	----	--------	--------
    46051	3/9/2012	AUD		USD		1.0573		1
    44392	3/9/2012	AUD		USD		1.06195		2
    43122	3/9/2012	AUD		USD		1.06585		3
    44394	3/9/2012	BMD		USD		1.0000		2   	
    44395	3/9/2012	BSD		USD		1.0000		2   	
    46052	3/9/2012	BWP		USD		0.13875		1
    44402	3/9/2012	BWP		USD		0.13925		2
    46053	3/9/2012	DKK		RON		0.5859		1
    44406	3/9/2012	EUR		CSD		110.62		2
    46090	3/9/2012	EUR		USD		1.3109		1
    44434	3/9/2012	EUR		USD		1.31185		2
    43154	3/9/2012	EUR		USD		1.32556		3
    44436	3/9/2012	FJD		USD		0.564		2
    43156	3/9/2012	FJD		USD		0.5686		3
    46092	3/9/2012	FKP		USD		1.51195		1
    44437	3/9/2012	GBN		USD		1.6339		2
    43185	3/9/2012	GBP		USD		1.57985		3


output should be :

    KEY		COB			CUR1 	CUR2	RATE		PRIORITY
    ------	--------	-----	----	--------	--------
    46051	3/9/2012	AUD		USD		1.0573		1
    44394	3/9/2012	BMD		USD		1.0000		2   	
    44395	3/9/2012	BSD		USD		1.000		2   	
    44402	3/9/2012	BWP		USD		0.13925		2
    46053	3/9/2012	DKK		RON		0.5859		1
    44406	3/9/2012	EUR		CSD		110.62		2
    46090	3/9/2012	EUR		USD		1.3109		1
    44436	3/9/2012	FJD		USD		0.564		2
    46092	3/9/2012	FKP		USD		1.51195		1
    44437	3/9/2012	GBN		USD		1.6339		2
    43185	3/9/2012	GBP		USD		1.57985		3


Please provide your inputs ?
