Hi!

I have a table with a few fields, one of them is integer type.
I want to get a record which value of this integer field is maximal.
What sql sentence should I use ?


How can I be sure, that there is only one record with this max value ?
Let say, that my values are 1,2,3,4,5,5.
Would there be then both records with value 5 returned ?


Regards,
Primoz