Help to develop the Query.

[sanmahicog sanmahicogg]

Hi All,

I want the query for the attached data formate, I have tried by using sub query but not able to get the output.


Table Data in Oracle

					
	Sr No	Engine Name	Rev no	Engine Type	Engine Color	Engine Norms
	1	A	1	Export	Red	BS3
	2	A	2	Export	Red	BS3
	3	A	3	Import	Grey	BS3
	4	A	4	Import	Grey	BS4
	5	A	4	Export	Yellow	BS4
	6	A	4	Import	Blue	BS3
	7	B	5	Export	Grey	BS3
	8	B	1	Export	Grey	BS4
	9	B	2	Import	White	BS3
	10	B	3	Import	White	BS4
	11	C	1	Export	White	BS3
	12	C	2	Import	Red	BS4
						
						
						
Required Output		I want the engine data with the highest rev. no.				
						
	Sr No	Engine Name	Rev no	Engine Type	Engine Color	Engine Norms
	4	A	4	Import	Grey	BS4
	5	A	4	Export	Yellow	BS4
	6	A	4	Import	Blue	BS3
	7	B	5	Export	Grey	Bs3
	12	C	2	Import	Red	BS4

[Wendy Gibbons]

sorry i don't understand your data enough to understand the question. what defines a unique "engine data".
Can you show us what you currently have please (even though it is not working)