Home » SQL & PL/SQL » SQL & PL/SQL » Find the maximum value.
Find the maximum value. [message #218845] Sun, 11 February 2007 08:40 Go to next message
matrik02
Messages: 64
Registered: November 2005
Member
I have a lot number, field1 until field6 in table Parcle. Lot number is the primary key.I would like to find the record.What field (field1 untill field6) have the maximum value?.Let say I got the the field 5 has the maximum value in the the record.So what the lot number have maximum value. How I can do that in SQL ? I use *.MDB database.Help me, I am a stupid student in programming
Re: Find the maximum value. [message #218850 is a reply to message #218845] Sun, 11 February 2007 09:45 Go to previous message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
> I use *.MDB database.Help me, I am a stupid student in programming
I agree with you. It is lousy design;plus you are posting a question about ACCESS in an Oracle forum.
Go ask your teacher for special tutoring.
Previous Topic: merging the data
Next Topic: I get an error when i try to set autorace on ..any help
Goto Forum:
  


Current Time: Sun Dec 04 08:29:38 CST 2016

Total time taken to generate the page: 0.04258 seconds