File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
A friendly place for programming greenhorns!
Big Moose Saloon
Register / Login
JDBC and Relational Databases
Help to develop the Query.
Joined: Jul 23, 2012
Oct 05, 2012 01:14:03
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
Joined: Oct 21, 2008
Oct 05, 2012 04:09:12
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)
I agree. Here's the link:
subject: Help to develop the Query.
UBB vs. HTML
Not able to apply decode function to my query
comments welcome to clearify...
All times are in JavaRanch time: GMT-6 in summer, GMT-7 in winter
| Powered by
Copyright © 1998-2015